Inspect columnstore deleted rows, measure delete-bitmap overhead, and choose targeted REORGANIZE work before a heavier rebuild.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Stored Procedure sp_datatype_info to Get Supported Data Types
Forget which data types your SQL Server version supports? I run sp_datatype_info, which lists every supported type with precision, nullability and searchability.
SQL SERVER – Automatic Seeding of Availability Database ‘DB’ in Availability Group ‘AG’ Failed With an Unrecoverable Error
Automatic seeding of availability database failed with an unrecoverable error: it showed on the secondary, then vanished. Here is what ERRORLOG said.
Automatic Seeding in Always On: List and Monitor It
Automatic seeding in Always On lets the primary send a database to a secondary without a manual backup and restore. Three read-only queries show which replicas use it, what happened before and how far a seeding run has come. It also covers why it fails and when to switch it off.
SQL SERVER – Getting Started with Accelerated Database Recovery – Instant Rollback
Killing a long transaction used to mean a rollback that took forever. SQL Server 2019 fixes that with Accelerated Database Recovery and its instant rollback.
How to Execute Query Without Using F5 or Query Toolbar in SSMS? – Interview Question of the Week #224
How do you execute a query in SSMS without F5 or the Query Toolbar? An attendee in a private training asked for a unique way, and here is a less known method.
Last Known Actual Plan in SQL Server: Query Plan Stats
The last known actual plan is the plan of the most recent run of a cached query, with its real row counts. This post turns the feature on for one database, reads the plan with sys.dm_exec_query_plan_stats and compares estimated rows with actual rows.
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.