You only need to install SP2 as they are cumulative.

Buxton69

Thank you very much for your comment Ed it makes it makes me a lot happier knowing that I did the best thing by leaving it to manage itself as...

I don't use maintenance tasks, I don't think you have as much flexibility with them but I've not really investigated them enough in 2005, I tend to use the same...

I checked the fragmentation using the contig microsoft tool, it wasn't that badly fragmented.

Hotspare, you must be pulling my leg 😀

I think I must look for the most difficult route! I feel so stupid now, why is there a KB on adding a registry entry for it!!!!!!!!

Thanks for not...

I know it's the drives, there are a lot of badly written queries but that's nothing compared with the drive, if you copy a file the whole thing slows down,...

Ahmed, thanks for the link, I think I'll use that, it looks like someones just adopted the Microsoft style,...

It's not the views, sp_MSforEachTable only works on tables.

I don't think it's the way that the indexes were created although that is very interesting to know, I think it's the...

How often does anyone else run CHECKDB? I try to run it nightly but once a week if I can't, the same with defragging indexes and index rebuilds, is...

65Gb, but it completely freezes everything out, it runs at 3am and when you get in in the morning the server is inaccessible, you have to switch it off, checkdb...

This is a good link to get all cumulative updates from:

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Six 300Gb drives, what it the easiest way to split them up with minimal interuption?

There's only one drive with RAID 1+0 and that's the one with all the user databases, log files, backups and system databases on at the moment.

I'm trying to get a different array controller put on the server so I can use another seven bays but until then I don't have much choice, there are 32...

I've got quite a bit of space so I had already split tempdb into four after reading this:

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1276989,00.html

One per CPU and they are 3Gb each with a 1Gb...