A SQL Server cluster install failed with 0x84cf0003: Updating permission setting for folder failed. Service account rights and folder permissions were fine. The cause was the Audit Object Access policy from a GPO.
EXCEPT Operator in SQL Server: Distinct Rows and Differences
The EXCEPT operator returns the rows of one query that are missing from another, with duplicates removed. This post shows the difference between two small order tables, the old WHERE 1 = 0 trick for distinct rows, and how NULLs behave.
The Ascending Key Problem: Estimates for Today’s New Rows
Diagnose ascending key estimates with histogram boundaries, modification counts, and controlled comparisons before updating statistics.
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.