Setup error 0x84CF0004 appeared when clients rebuilt system databases with SQL Setup. The log said the permission setting update failed for a job history file. Moving the JOBS folder aside and creating an empty one fixed it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Plan Cache Memory by Cache Store: Where Plans Use Your RAM
Break down plan cache memory by cache store and object type, compare memory clerks, and investigate unused plans without cache clearing.
DevOps for DBAs: Build, Test, Release and Monitor
DevOps for DBAs means bringing development and operations together for the whole software lifecycle. Here is a simple definition, the four steps of the loop, and what they mean for SQL Server.
Index Slows Down SELECT? What an Unused Index Costs You
An index slows down SELECT queries only in small ways when the plan never reads it. This post measures compile memory with twelve unused indexes, shows the plan change when a related index appears, and counts what every insert and update pays. The real bill arrives on writes.
Every Second Item Free: Pricing Promotions With ROW_NUMBER
Price every second item as free with ROW_NUMBER, expand quantities into units, and calculate basket discounts without double counting.
When was Table Accessed Last By User? – Interview Question of the Week #226
When was a table accessed last by a user? When clients say a table is rarely used, I run this report to check before we create or drop indexes.
Setup Error 0x851A0012: REBUILDDATABASE Needs the sa Password
Setup error 0x851A0012 appeared while I helped a customer rebuild corrupted system databases after a hardware failure. The command had no SAPWD parameter, and the instance used SQL Authentication Mode. Adding SAPWD let setup finish.
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.