jcolebrand

3,659 reputation

11648

bio	website	jcolebrand.info
	location	Plano, LA
	age	33
visits	member for	2 years, 4 months
	seen	3 hours ago
stats	profile views	1,054

I'm now working for a group out of Plano, doing primarily front-end work for mobile and online banking for credit unions. Time for me to get involved in the local user groups!

combined Stack Exchange profiles for jcolebrand

You probably want to gmail me if you need me directly. If I have to tell you what gmail address to guess at, you're not trying hard enough.

Everything else can be found at http://jcolebrand.info or http://about.me/jcolebrand

	3,659 reputation	bio	website	jcolebrand.info	visits	member for	2 years, 4 months
11648 badges		location	Plano, LA		seen	3 hours ago

summary answers questions tags badges favorites bounties reputation activity

1,738 Actions

suggestions reviews revisions comments badges posts accepts all

May 16	comment	Oracle RAC 11g R2 DB silent install: parameter needed for system class Hi Toze and welcome to the site. Can we get you to add a bit of commentary as to why this would be helpful? That would certainly help others coming along after!
May 15	comment	Oy! Changes ....
May 15	comment	@AaronBertrand I have no doubt of that. You do what I do and disappear from the network when you get frustrated, which is the right thing to do (I think so anyways, as that's what I do ;-) )
May 15	comment	Another facet that might be of good concern is that we should be having a "Town Hall Chat" so if you want to keep your questions to ask the mods at that time, you're welcome to tune in for that (but keep in mind that we may schedule that at a time when you're unavailable). Regardless of availability, there will be a meta post for that topic in the very near future.
May 15	comment	For those who don't know, there are a few ways the mods keep in touch with one another on network that give us plenty of room to defer to other mods to handle a situation, and we use those other methods quite frequently. I for one am known to have a short fuse, and it's really easy to open one of those other lines of communication and go "I'm pissed, and I'm leaving. One of you deal with this asshat" ;-) Sometimes all that's needed is a fresh perspective, and sometimes you just need a night's sleep, and sometimes you just need to ignore the situation.
May 14	reviewed	Approve suggested edit on SQL Server simple model database transaction log full 'CHECKPOINT'
May 14	comment	DB Design - Which of the two is best-Normalized or Not Closed in deference to the Q posted on Stack Overflow
May 13	awarded	Caucus
May 6	reviewed	Approve suggested edit on MySQL user defined rollback procedure
May 2	revised	DB comparer field by field for all tables deleted 13 characters in body
May 2	comment	DB comparer field by field for all tables Free versions of SqlCompare? gimmmegimmmegimmmmmmee :D
May 2	comment	DB comparer field by field for all tables There are no "free tools", but if you're willing to do some work, and you're using C#, you could always use something like "FluentMigrator". Otherwise, your best bet is to actually pay for Redgate's SqlCompare package, it's the industry standard, at least for TSQL, that I know of.
May 1	comment	Force sql server to run query conditions as written? Could you maybe elaborate on what the "if/else construct" might look like? :D
Apr 29	comment	Network Databases Closed because this is a list question, which should be available on wikipedia. List questions aren't good SE questions, as has been decided over and over (see metas everywhere). If more specific help is needed, you might try chat to see if we can help there within. HTH. YMMV. Cheers.
Apr 17	comment	MySQL and window functions Just for what it's worth, your links are right outdated, you should really reference that those are for older versions.
Apr 10	reviewed	Approve suggested edit on Main Considerations When Moving From MS Access Programming to SQL Server
Apr 9	comment	Hash in SQL query Where, specifically, did you find these hashes? In a file? In a stored proc? Looks like MySQL based on the backticks, but idk
Apr 5	comment	Gaps and islands: client solution vs T-SQL query finding and counting islands is not a strong suit of either TSQL or C#, so the solution should be "slow" in either, that's what I mean about "the absence of sets". As for "providing abstracted ... examples" I'm only stating that most people look for islands over the entire table, but if you can break out a subset that doesn't need a tablescan of the entire table, you can improve performance. Just pull the columns you need to actually scan over into an indexed table, instead of looking at every single row. (most of these are date based queries, when looking for islands)
Apr 4	reviewed	Approve suggested edit on SQL Server 2005 Express in VMware causing very high CPU load
Apr 4	comment	Gaps and islands: client solution vs T-SQL query I think that in this particular case, the C# is better able to optimize the situation. I expect that if you abstracted the data from the tables into properly optimized temp tables, that you could get faster set relational work out of the database, but when doing arbitrary work, that isn't set oriented by it's nature, that C# is the stronger design in the first place. SQL is designed for set oriented work. Islands aren't sets. They're the absence of sets.