Careful reading would have helped to win the point... 😉

Thanks for the question and teaching me the lesson to first read, understand, think and only then reply.

Additional information can be...

Some may find this additional information on Recovery Models of System DBs helpful:

http://msdn.microsoft.com/en-us/library/ms365937.aspx

Enjoy,

Michael

Apparently trusted the wrong reference on MSDN:

http://msdn.microsoft.com/en-us/library/ms191220(SQL.90).aspx

as this gives a list of 6 automatically created endpoints...

Thanks for the question and for teaching me to doubt any of the Microsoft online...

Wayne,

first of all thank you for compiling a QotD.

However, I do not quite agree with the solution.

'Unique' is just taking the definition of a clusterd or non-clustered index a step...

My gutt told me to go for option 1, but not because of it running faster, but because I wondered why one would change a non-nullable column to nullable (especially...

Hugo Kornelis (7/13/2010)

---

Both the text before the first delimiter and the text after the last delimiter will be a row, as each bit of text between two delimiters. That results...

michael.kaufmann (7/13/2010)

---

jcrawf02 (7/2/2010)

---

Not sure why this one is tripping folks up, if you just count the delimiters, you can see it will return 13 pieces?

...anyway...good question, I'm sure it's introduced...

jcrawf02 (7/2/2010)

---

Not sure why this one is tripping folks up, if you just count the delimiters, you can see it will return 13 pieces?

...anyway...good question, I'm sure it's introduced some...

Just verified the finding in SQL Server 2005:

- With MODEL being in READ_ONLY mode, when creating a database using the wizard, it is created read_only. No more changes are possible.

-...

G² (10/1/2009)

---

This is straight from the link supplied in the answer.

SQL Server 2008 introduces several extensions to the GROUP BY clause that enable you to define multiple groupings in the...

FYI:

In SQL 2000, the code runs without any errors--data is input into the table and the query returns 1,2,3,4,5 and 6.

In SQL 2005, database in compatibility mode 80, the data...

Aha--the trick is to run the second part in another query window ... not the same one (in which case all 3 records will be returned).

Should have followed the instructions...

Unfortunately I don't have a test setup at hand either and perhaps I'm again misinterpreting the information in the MSDN article the QotD is referring to, but in my opinion...

Apologies for my wholistic approach and for quoting MSDN.

You are perfectly right and I fully agree.

However, my comment was targeted at the way the question of the day was worded--there is no indication of where the trace would...