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 Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
Drop Multiple Tables with One DROP TABLE Statement
To drop multiple tables in SQL Server, list them in one DROP TABLE statement, referencing tables first. This post tests the order rule on a parent and child table and shows what happens after an error. It also covers IF EXISTS, drops by name pattern and temporary tables.
PREEMPTIVE_OS_DEVICEIOCONTROL: DBCC CHECKDB Will Not Stop
A DBCC CHECKDB session waiting on PREEMPTIVE_OS_DEVICEIOCONTROL did not end, even after a stop job and a kill. The wait is outside SQL Server’s control, so nothing inside SQL Server could clear it. Restarting SQL Server removed the session.
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 slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.