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