Curated Scripts Library

This table was created as an effort to curate and organize the excellent scripts found during my travels, and represents curated copies of what are, in my opinion, useful scripts.  It is my intent to highlight the author’s great work, to guide others towards each author so that readers of this blog can be exposed to the many authors that I follow, and to give proper credit to their creators. Please visit their sites and support these authors as I believe they are all incredible resources for the SQL Server community.

I also need to say that the information provided on this site is provided “AS IS, AS AVAILABLE” with absolutely no warranties, and confers no rights. In simple language, I am not responsible or liable for your use of these scripts or any information provided on this site. I do not guarantee their accuracy, or that they are error free. I am not liable for any potential damage that they may cause due to their use. Use any information on this site at your own risk.

This weblog does not represent the thoughts, intentions, plans or strategies of my employer. It is solely my opinion.

It is also my opinion that any script you choose to execute, regardless of source, should be thoroughly tested in beta environments prior being used in a Production environment.
You have been warned.

Curated ThoughtsDescriptionScriptTagsAuthorAuthor PictureLink
Determine whether a table with Data in it would benefit from compression

SQL Server provides the sp_estimate_data_compression_savings stored procedure to help you determine whether a table with data in it would benefit from compression.
For more information about table compression, see “Data Compression” at http://msdn.microsoft.com/en-us/library/cc280449.aspx
and “sp_estimate_data_compression_savings (Transact-SQL)” at http://msdn.microsoft.com/en-us/library/cc280574.aspx. (Page 275)
sp_estimate_data_compression_savings, Table CompressionItzik Ben-Ganhttps://www.microsoftpressstore.com/store/training-kit-exam-70-461-querying-microsoft-sql-server-9780735666054