Nice question, thanks.

Though I think formatting the code into little sections, and including the commented select statements, makes it a little more confusing and harder to read than it could...

Nice question, thanks!

Related BOL links:

SQL Server 2008 R2: http://msdn.microsoft.com/en-us/library/ms175010.aspx

SQL Server 2008: http://msdn.microsoft.com/en-us/library/ms175010(SQL.100).aspx

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

SQL Server 2000: http://msdn.microsoft.com/en-us/library/aa260638(SQL.80).aspx

All of them say:

* "Transactions involving table variables last only for...

Very timely article, and discussion, as I am just about to setup an automated restore job for a DB. Thanks!

Thanks for the question, I think it helps re-enforce some of the less known internal workings of SQL Server.

Erin-489205 (9/28/2010)

---

Thank you. I sent this to our network engineer so he can confirm the server model. However, we are running Server 2008 the article mentions 2003. ...

GilaMonster (9/30/2010)

---

It's more correct to say the other way around. A group by with all the columns in the group by clause behaves much the same as a distinct when...

Thanks for the question, it made me slow down and think.

Since you wanted some more R2 data points, I ran both of the tests on our SQL Server 2008...

Duh. I was so busy thinking...

Are you sure he designed that table? Maybe he inherited it and isn't allowed...

David, That is an interesting way to do it, but I think it is less readable for us bit-challenged people. 🙂

PaulB-TheOneAndOnly (9/29/2010)

---

mmmhhh... since DISTINCT does not allow for aggregations I wouldn't say that DISTINCT is doing "an automatic GROUP BY"

DISTINCT and GROUP BY are two very different tools as pointed...

Lowell (9/29/2010)

---

for your "X12X" example, you need to define the rules...two X's woluld both get replaced with the same number in my example...your's seems to increment, but not in a...

You didn't specify how the time portion of the EventDate field should be dealt with so I assumed that you only wanted to look at the date not the time.

Give...

He didn't want a non-parallel plan, he just wants...