Hi,

This QOTD may not be as clear as it seems.

While you (as asked in the question) can certainly run 2 of these backups at the same time without getting an...

Koen Verbeeck (12/14/2011)

---

Great question!

I have a question:

why doesn't the second 'drop table' statement drop the table in the master database?

Won't the statement look for the table in the master database,...

Well, you...

L' Eomot Inversé (12/12/2011)

---

What's the most important use of SQL_VARIANT order? Well, in my experience its main use is in generating T-SQL trivia questions for use as QotD -...

I liked the first question in the series, but I did not really need the follow-ups.

The first question already taught me to never ever consider order by SQL_VARIANT columns.

Maybe I...

Why not in prod?

Don't you have 82 GB left for 32,767 empty Databases? 😉

I tried it with 1001 though (on my local machine of course!) and at these 1001 DBs...

Very nice question series. By the way, you could make the query fail using

as well.

elbedata (8/23/2011)

---

It returns "that" when I test on SQL Server 2008, but I thought it should return "this"...

Has this changed in later SQL versions? I am pretty sure I've learned...

The fact that test2 does not exist is not a syntax error.

pksutha (3/23/2011)

---

Hi Gopi,

select * into TestTable from

(

select CAST(1 as smallint) as C1, CAST(6 as smallint) as C2

union

select CAST(2 as tinyint),CAST(6 as int)

union

select CAST(3 as bigint),CAST(6 as smallint)

union

select CAST(4 as int),CAST(6...

If you...

I liked the QOTD and especially the Niagara Falls idea.

Hi Ron,

these pages are correct.

Only the Answer & Explanation of this QOTD are paradox.

While the Explanation is correct, the Answer is wrong.

Come on, Steve! Make a decision. You cannot have both 🙂

Paul Randal (5/13/2011)

---

Steve - I got this wrong because your wording is broken. Extents can NOT be owned by multiple objects. When an extent is a mixed extent, it is...