Inspect columnstore deleted rows, measure delete-bitmap overhead, and choose targeted REORGANIZE work before a heavier rebuild.
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.