I do like the diff backups idea. It makes life much easier when dealing with 15 minute t-log backups. As far as index fragmentation goes, I scan all...
I do update stats. Just forgot to mention. I don't need to do anything else like rebuild procedures or anything else of that sort?
All, I do not like using the native sql server 2005 maintenance plans but rather script out tasks to perform maintenance. I do the following......
We are currently an IBM shop; however, IBM seems to not understand basic I/O configurations with SQL Server and I am pulling my hair one piece at a...
Separate names with a comma.