Diagnose ascending key estimates with histogram boundaries, modification counts, and controlled comparisons before updating statistics.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
IIF in SQL Server: IF THEN Logic Compared With CASE
IIF in SQL Server is a short way to write IF THEN logic with two outcomes. This post compares it with CASE in a small juice shop table, shows that both produce the same plan, and covers NULL, data types and the WHERE clause.
How to Track Autogrowth of Any Database? – Interview Question of the Week #205
How do you track autogrowth of any database? Constant autogrowth was slowing a client’s busy e-commerce database, and here is how we found when and who caused it.
SQL SERVER – T-SQL Script to Check SQL Server Job History
SQL Server Agent Job History can be queried from msdb. A New Zealand customer requested this report during our weekly health check.
SQL SERVER – How to Write Correlated Subquery?
A Correlated Subquery references the outer query. I use a stock-item comparison after the earlier single-table aggregate lesson.
SQL SERVER – Two Different Requirements for a Single Table Subquery
A subquery can compare rows with an aggregate from the same table. A junior DBA asked about this over lunch.
SQL SERVER – Cannot Shrink Log File Because Total Number of Logical Log Files
Cannot shrink log file because the total number of logical log files cannot be fewer than 2. Here is what the message means.
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.