Thanks for the question!

Thanks for the question, things like this are what usually causes problems for people in an upgrade.

Thanks for the article, it makes a good point in that in some cases a SQL Server backup isn't enough, and that having an actual copy of the DB files...

Jeff Moden (2/2/2011)

---

BWAA-HAA!!! Thanks for the great feedback, David. And, just to make sure, I have to tell you that that version of the Tally table splitter has...

Thanks for the question, though I did have to check BOL to make sure how I wanted to answer.

Thanks for the explanation wolfkillj! That makes total sense now.

Thanks for the question, it is good to know that SQL Server decides to return NULL for the standard deviation for a data value, though I don't think it is...

Thanks for the question, I learned something new. 🙂

william-700725 (1/27/2011)

---

[font="Courier New"]About time somebody pointed out the convenience of the standardized formats. I've been using UCASE( CONVERT( char ( 11 ) , GETDATE() , 106 ) ) to create...

Steve Jones - SSC Editor (1/26/2011)

---

Note that disks still fail. It's why when data is really critical, you can't necessarily wait on a rebuild. A disk failure from the same...

Really? I have...

Thanks for an easy start to the day!

Jeff Moden (1/21/2011)

---

Ok... here's the test data generator that I borrowed from Wayne's article. I set it up for 10 times more rows and 10 times more accounts for...

Here are the results from my development server (HP ProLiant ML350G5, dual quad core E5430 @ 2.66GHZ, 18GB) SQL Server 2008 R2 CU5 Enterprise Edition x64 on Windows Server 2008...

Thanks for the question.