DBCC for your SAN, Hyper-V and Windows stuff

Most SQL folk know that we need to run DBCC frequently and the lucky ones who have attended some Paul Randal training (www.sqlskils.com) will be well aware of the intricacies of DBCC CHECKDB and when/how the repair databases and data loss risks. Well what if you also have a SAN and clustered Hyper-V environment instead … Continue reading DBCC for your SAN, Hyper-V and Windows stuff

Compress an entire database

By Bob Duffy16. September 2011 04:30http://www.facebook.com/widgets/like.php?href=http://blogs.prodata.ie/post/Compress-and-entire-database.aspx I posted a script earlier to generate the script to compress an entire database. here is one to do the compress/rebuild partition by partition. one thing to bear in mind is that ONLINE rebuild is not supported  when rebuilding partition by partition. See http://technet.microsoft.com/en-us/library/ms188388.aspx  My simpler script to just do compression … Continue reading Compress an entire database