I wondered at first as well...then I noticed the...

That does make sense. I always knew it was a DDL and not a DML operation, I just never really gave much thought to the definition of fully vs minimally...

I was asked this very thing in an interview a while back. Except, they wanted to know if a TRUNCATE was fully or minimally logged. While I mentioned that all...

Unfortunately, my summer has been just one arrest away from a country song. Hey, it happens...I'm just glad football season is around the corner.

I am one of the guilty ones of always using ISNULL instead of COALESCE. It stems from habit. I've been using ISNULL for 10 years and only stumbled...

Excellent Question and learned something new!

This is what threw...

"Suppose I have two schemas" does lead the reader to consider that the user only has access to those two schemas. I initially was looking for Success, Success, Fail, but...

I read this question completely different and ended up getting it correct anyway. I guessed two because of '[' and ']'....

I'll take it! 😛

I got this question correct because I was thinking of my own preferences. I do not like allowing NULL values or turning on CASCADING....so it made sense not to...

Good question, can't wait until I actually get to start using 2012.

I guessed 9 because there were 9 statements and I couldn't find anything documented about a particular behavior of them in estimating a query plan? After plugging it into SSMS...

Glad to see I'm not the only one perplexed by the explanation. I was starting to wonder if something was really wrong with SQL 2008 and it slipped right by...

Nice question and I learned STUFF.

The oddity that I find interesting about this question is the fact that the UNION automatically sorts the results. In my head I'm thinking the results would be 4,7,2,8...