I can't really defend keeping Autoshrink on but I can say that it has been left on in our...

Great job with the article and an excellent example of how the same code will perform differently under various data loads.

Clearly, the answer "it depends" can be justified as you...

Nice question!

I spent 5 minutes reading here:

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/29/Enabling-CHECKSUM-in-SQL2005.aspx

It does not give the specific answer but I was able to deduce the correct answer from the information given.

An excellent balance of difficulty...

john.arnott (1/28/2010)

---

...It's not that a BIT datatype has three states -- wouldn't that be a "trit"? -- but that ANY data element may be designated as nullable or not, and...

A little more information about the BIT type. The bit type has 3 states: NULL, 0, and 1.

When first declared and unset a NULL will be returned.

Only a 0...

Bob Cullen-434885 (1/28/2010)

---

OK. I am in the 17% who got it wrong - I replied "Error". And now I know. But will somebody kindly explain why BIT is treated any...

That's what I get for answering before having my coffee. :doze:

I picked '%im' because of course % is a wildcard. But it will return more than just Kim or...

I totally agree. ...

Steve, thanks for fixing...

I can understand the confusion with this question since msdn refers to IN many different ways. A number of msdn links have already been posted to defend different answers...