Nice question, Satish, thanks. It's good to know about INTERSECT; it's like an inner join, but with all of the columns automatically put into invisible ON clauses:

SELECT A.ID

FROM A

INNER JOIN...

Thanks for the question, Andy. I haven't worked with filetables, so I wasn't sure about this (and I got it wrong :(). I was able to deduce that the file...

Nice question, Andy, even if the explanation of the subdirectory limit was incorrect. I also found the first answer easy (I knew it was new to 2012), but picking the...

I agree with Tom that the statement about multiple identity columns had nothing to do with the question. Otherwise, it's a nice, simple question when you see the TRUNCATE TABLE...

Easy one. Thanks, Steve.

That's a gold star for getting the correct answer!

I agree with a lot of people here, the correct answer should be 3, based upon structure, not decorations:

SELECT x AS y

SELECT x y

SELECT y = x

Brackets, quotes, or double...

It's much better to make the combination harder by doubling the numbers. 2,4,6 is much better, don't you think? 😀

Nice easy question, Steve, thanks.

I have used version control (SourceSafe, StarTeam, RCS, TFS, and a couple others) at several jobs now, and I think it's very important, for all of the reasons previously mentioned...

Nice, easy question. Thanks, Raj!

Nice question, Andy, thanks. I was somewhat expecting the answer to the second query to involve lots of asterisks (e.g. "***-**-****" or "***********"), but since none of the choices included...

I was also able to guess the correct answer (I'm not a DBA). Thanks for the question, Steve.

Great question, Justin, thanks!

Good question, Robert. I got burned, because I always use BEGIN..END in my procs for readability, but I always put GO after them to end the block. When I read...

Thanks for the terrific question, Kathi! The only criticism I have is that your explanation only states why number 3 is wrong and does not discuss the difference between number...