Is there a way to know the compression ratio of backup files in SQL Server? Here is a quick script on msdb backupset that compares backup size with compressed size.
SQL Authroity News – Optimizing Lazy Spool – PASS Blog
A sneak preview of my SQLPASS sessions: I wrote about optimizing Lazy Spool on the PASS blog, and here are the first two paragraphs with a link to the rest.
SQL SERVER – Reporting Services Not Starting After Maintenance Window
Reporting Services not starting after maintenance? On my lab server every SQL service came back except SSRS. Here is what the log showed.
SQL SERVER – How to Get List of SQL Server Instances Installed on a Machine Via T-SQL?
A registry query lists SQL Server Instances recorded on the Windows host. A customer wanted a T-SQL-only method.
SQL SERVER – DBCC CHECKDB Waiting for PREEMPTIVE_OS_DEVICEIOCONTROL
A weekly DBCC CHECKDB job was stopped by a terminator job, but its SPID stayed, waiting on PREEMPTIVE_OS_DEVICEIOCONTROL. Here are ways to handle that situation.
Do Index Reorganization Update Statistics? – Interview Question of the Week #196
Question: Do Index Reorganization Update Statistics?
Answer: No. Index Reorganization does not update Statistics of your database.
SQL SERVER – Unable to Create Always On Listener – Attempt to Locate a Writeable Domain Controller (in Domain Unspecified Domain) Failed
Can’t create an Always On listener? On three clusters, Event ID 1212 said the attempt to locate a writeable domain controller failed. I walk you through the fix.