EAV tables are a scourge upon the data landscape. We have several vendor applications which seem to be using EAV as an extreme form of obscuring what they deem to be valuable...

Thanks for taking the time to write this up. Excellent job, and very timely!

sgmunson (1/26/2015)

Yes, sub-queries do have uses. As clearly demonstrated by the execution plans, the original query could be problematic in performance with 4 scans of the clustered index...

They do have use. For some complex queries, the engine sometimes needs help. Adding a derived table in just the right part of the query can make it easier for...

I agree with a lot f what has been said. I would add that spreading the knowledge, particularly to developers helps them be better developers and me a better DBA....

I have recently moved to a job where I am expected to refactor a substantial part of the code base, particulary around BI. This is new work, altough I have...

Working in the legal industry, I can say that there is both a desire and the resources to make HA real. The last firm I worked for runs 2 large...

Do you run a dev environment on a different domain. If so, look there. You might find a machine has been imaged from production and placed in your dev domain....

Smack the back of their hands when they try to.:hehe:

If you have a DBA reviewing code before it goes into production, it is done at this point.

If you are...

...and do almost everything that is neccessary to avoid nesting your views. No matter how well your query is tuned, you will get performance issues sooner or later when nesting...

2a) Be aware Hashing isn't foolproof. 'ab' + 'cabc' looks the same hashed as 'abc' + 'abc'. Every now and again you'll need to 'reset' the data to...

Ah, I get it now. Funnily enough, that was what I said to get my current job. A lot of "I haven't done that for 5 years" or "I have...

Not sure if I get your meaning Evil, if that is your real name :P. Why would you get someone in if their resume doesn't even contain recent experience relevant...

I recently had to conduct interviews for my own replacement. I had conducted interviews before, not many but a few, and basedthem arround technical questions. Just kept on hiring the...