A simple query I run at customer sites to list every table with its size in MB and Row Counts, including used and unused space.
SQL SERVER – How to Find Row Count of Every Table in Database Efficiently?
How do you find the row count of every table in a database without a cursor? An interview question, answered with a fast query instead of a loop.
SQL SERVER- Error: 18204, Severity: 16 – Backup Failure – Operating System Error 1240 (The Account is not Authorized to Log in From This Station)
A client’s backups to a file share failed at random with error 18204 and OS error 1240. The error message pointed to the real cause of this Backup Failure.
SQL SERVER – How to Change Database Compatibility Level?
Compatibility Level controls selected query behavior within a database. I baseline the workload before changing it.
How to Find Running SQL Trace? – Interview Question of the Week #123
Question: How to Find Running SQL Trace? Once we know the trace exists, how to stop and delete them?
SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
SQL Server Configuration Manager said: cannot connect to WMI provider, you do not have permission or the server is unreachable. Here is the fix.
Script Upgrade Mode in SQL Server: Login Failed (Error 18401) While Deleting a Collection Set
Script upgrade mode can reject logins for a while after a SQL Server update, and in this 2017 client case the startup log stopped at a collection set cleanup. This post shows how to read error 18401, check whether the upgrade still moves and size the msdb logging tables with tested queries.