CUs aren't meant for installation just because they are released, Microsoft says to only install them if they are supposed to resolve an issue you are experiencing, but I think...

We are currently running 2008 R2 CU5 in production (and we are about to evaluate CU6 on the dev server.)

In our case if we didn't put CUs in production we...

2008 and 2008 R2 have the same support end dates, so support shouldn't be a problem. But for example in our shop we now only have 2008 R2 on our...

Thanks for the question.

I would say that 4 is the correct minimum, otherwise you just have RAID1. (You are just mirroring two drives.) You don't get the +0 until you...

Yeah, I like that... "We know about it, but it would take too much to fix, so just whack it when it becomes a problem..." 😛

Thanks for the question.

Changing the compatibility level only changes...

Steve Jones - SSC Editor (3/3/2011)

---

The questions has been corrected (again, sorry) to note that 2 answers are required. The standard MS tests tell you how many answers you...

Thanks for the question, it is nice to know that the RG gathers the stats even when it is disabled.

Serge Mirault (3/1/2011)

---

Hey thanks for the reply!!! I realize you can use the NORECOVERY option but that keeps the DB in a mode where we can't test anything as...

Serge Mirault (3/1/2011)

---

RESTORE DATABASE [MyDB] FROM DISK = N'\\SAN\SQL_Backups\MYServer\MyDB\MyDB_backup_201102281747.bak'

WITH FILE = 1, MOVE N'mydb' TO N'D:\SQL\DATA\mydb.mdf',

MOVE N'mydb_log' TO N'T:\SQL\LOG\mydb_log.ldf',

STANDBY = N'F:\SQL\LOGSHIPPING\ROLLBACKFILES\mydb\mydb_DisasterRecovery_UNDO.BAK', ...

Thank you very much for the article, it is good to learn about the pitfalls before actually falling into them.

Thanks for the question, though like a number of others I am confused about why 4 1000 byte rows would fill a 8192 byte page. (I know there is overhead,...

mika.sutinen (3/1/2011)

---

Thank you for the parallelism information, good stuff, hopefully we get to read your article soon. I am curious though, is there a percentage of CXPACKET waits that'd immediately...

James Goodwin (2/28/2011)

---

That's a fairly nice solution to the problem, however...(There's always a but...)

The biggest problem I see with your approach is that when someone wants to add a new...