I hadn't considered that. I will definitely have duplicates of natural keys that exist in different statuses while some of the status should be able to duplicate and Active...

Misunderstood. Apologies. So,...

Shifting gears a bit, I'm hoping this year that work will be happy to pay (or at least contribute) to me getting out and going to some SQL based...

Whoops. You didn't have to...

That got posted before I intended.

Natural keys for relational references within the DB are always bad. Natural keys can change which destroys referential integrity, they can't survive data corrections,...

Ha! I may have overly played up the "scary" part of the scarydba occasionally.

• This reply was modified 2 years, 9 months ago by Grant Fritchey. Reason: typo

Exactly. I totally understand why he does...

This could start a flame war! I've seen instances of otherwise-seasoned coders on here using the dreaded

;WITH CTE...

.Please no >_< .Leading commas I accept as a preference, but leading semicolons are another matter entirely, lol .Those are like...

.Please no >_< .Leading commas I accept as a preference, but leading semicolons are another matter entirely, lol .Those are like...

Heh... if I were really smart, I'd just up and retire.  That would probably kill...

Don't get me started in WITH (NOLOCK). Apparently there are a number of people suddenly making that recommendation to get rid of blocking.

It's apparently easier advice to give people...

FFS

What a pain in the bottom.

I did agree with Jeff though. The answers on that other forum stunk.

To my knowledge, primary key or not, temp tables are cleaned up at the end of a connection. I'm not aware of circumstances that prevent this. Of course, a global...

Predicting the future is something I'm pretty bad at. Could something completely eliminate the need for a role that resembles that of the database administrator? Sure. What does that look...