Cumulative Updates are only intended to be applied if you have the issue. You have not installed yet so don't have the issue. 🙂

I would install the vanilla version. We...

Jason, your avatars just get scarier and scarier............:-D

Ha Ha - very similar question to the fun question last christmas day so I got it right.

Last time I got it wrong and took a 25 point hit which...

My testing shows an index build to be serial even with maxdop specified (it allows me to specify a maxdop value) so I will have to accept it is.

the links...

thanks, but I am after confirmation that standard edition index rebuilds will always be serial, rather than you are just not able to explicitly specify a maxdop value.

Hmmm...did I misunderstand the question?

Be aware if you suspend the mirroring session, you will not be able to truncate the log of the primary .

no housekeeping is required on a mirrored database. Maintain the primary.

a database won't detach if someone is connected to it, so check that.

rowmodctr counts the total number of inserted, deleted, or updated rows since the last time statistics were updated for the table, so a reindex would not affect it.

run stats_date or...

if you are using windows 2008 this is done automatically....

some suggestions if not already done:

improve reindex job to only run update stats on indexes where alter rebuild was not run

do you really need to do full scans?

put the log...

I would run a checkdb on the database in question as well, as advised.

ta da!

http://www.sqlservercentral.com/blogs/glennberry/archive/2010/10/09/what-are-physical-sockets_2C00_-physical-cores_2C00_-and-logical-cores-and-why-does-it-matter_3F00_.aspx

grahamc (11/11/2010)

---

getoffmyfoot (11/11/2010)

---

Sounds like the cores are hyperthreaded.

Which brings up a tangent of mine - I have heard that it is "best practice" to disable hyperthreading on a windows...

tim.steorts (11/11/2010)

---

George,

You're right!

For some reason, the first time I tried to offline it, that process just hung, and wouldn't even come back with an error except to say it timed...