Guys, rather than repeatedly lamenting how terrible it is that you got the question "wrong" (as did I) even though it works in SQL 2000 / 2005, can anyone explain...

Hi Rich,

This seems to scare some people but it works very nicely in my experience:

By setting stored procedures as being a "system object", you can create them in the master...

Interesting article, it would probably benefit from at least a passing mention of the built-in stored procedure sp_help, mentioning how the custom procedure is better or more appropriate for a...

Sorry, just another "Me too!":

I got this error for the first time today (in the windows System event log, slightly different message but found exactly the same in the...

ok, so based on the question editor's comment above, this QOTD is broken - I answered the only one that contained only valid values (the one starting with "2009-02-01 00:00:00:000"),...

I agree with the comments above, but on the other hand I understood why the question's "Right" answer had to be the Identity function - I had never heard of...

Thanks Noel, that makes sense - I'm not sure it's very "cheap" because the clustered index gets rebuilt when it gets re-enabled (according to the BOL article), but still seems...

I agree, this is a very good question, but there's something I can't figure out or find in a quick search: Why would you ever want to disable a primary...

I don't mean to be overly picky (it's a good question, the intention was clear, and I got my point 🙂 ), but Truncate Table will not necessarily reset the...

Amusingly, I spent over an hour on this today and found the same solution (creating an index on backupset.media_set_id). Only after sorting it out on all our servers did I...

My comment (not that I'm very possessive about it 🙂 ) - I guess there's some sort of bug in the forum around edits.

strange - my post above was reassigned to Andy Warren! 🙂

I guess there's a bug in the forums??

Hi slange,

I think you're confusing a couple of possibilities.

The query above reports employees who have no "subordinates" - there are no employees that have their employeeid in the reportsto field.

The...

Hmm, nice one, I've never seen that issue described.

That provides another reason why the following syntax is (in my opinion) preferable:

select *

from employees

left join employees as subordinates on...

A slightly easier way to explain might be the fully-written-out equivalents of the IN clauses.

I've taken the liberty of "paraphrasing" T-SQL Syntax a little here, as there is no way...