having applied SP2 you certainly wouldn't apply CU6,7,8 for SP1, they wouldn't apply anyway as they are previous to SP2.

What MS do is bring out a CU1 for the latest...

yes, service packs are cumulative.

pleasure

sounds like an explorer display issue rather than a sql issue, so I dont think you have a problem here, especially as they cycle OK..

In explorer in organize view is...

read the blog from paul randal anthony posted and check out the scripts it links to which determine if you have tempdb contention. If you have no latch contention on...

<sigh> were the auditors dbas?

thats a rather blanket recommendation, and there are lots of other recommendations than one file per core.

The recommendation should be that if you are not using...

nice reminder, thanks. Good to hear the table only has one clustered index! 🙂

The points in the link about logging behaviour when you batch up bulk imports are important to...

if you just need to know who is in what database role use this

SELECT 'EXEC sp_addrolemember [' + dp.name + '], [' + USER_NAME(drm.member_principal_id) + '] ' AS [-- AddRolemembers]

FROM...

L' Eomot Inversé (9/4/2012)

I can't imagine anyone saying d-ar-tabases, but...

On the subject of pronunciation I would like to make it clear that we look after d-ay-tabases, not d-ar-tabases

🙂

In SQL2005 a restore of any database in an instance caused the proc cache to be flushed, this would lead to a peformance hit. You would see messages to that...

even if you back the log up to the same location as the log shipping backups it will still break log shipping as it will not be reflected in the...

you don't need any other log backups than the log backup job created by logshipping. Indeed, if you take other log backups it will break logshipping.

The log backup taken by...

with sql server 2008 there is a back door, if you have admin on your machine you can start sql server in single user mode and then add an account...

use the rolling upgrade method -

http://support.microsoft.com/kb/958734