My SQL puzzle: which queries create the most TempDB IO and grow its size? Answer with any DMV, and all valid answers get published here with credit.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Resumable ADD CONSTRAINT in SQL Server 2022: Pausing a Primary Key Build
Use resumable ADD CONSTRAINT in SQL Server 2022 to pause a key build, inspect progress, resume safely, and understand abort behavior.
hierarchyid GetLevel: Count the Path Depth
hierarchyid GetLevel identifies depth within a logical path. The read-only example distinguishes the root, children, grandchildren and a fractional sibling label.
SQL SERVER – Corrupted Backup File and Unsuccessful Restore
Called in to tune an OLTP server, I ended up helping a Jr. DBA whose restore kept failing. Here is the story of that corrupted backup file.
SQL SERVER – Taking Multiple Backup of Database in Single Command – Mirrored Database Backup
Two DISK targets in one BACKUP command split the file, they do not copy it. Learn how a mirrored database backup takes multiple backups in a single command.
Stored Totals: Find Drift Before Repairing It
Stored totals can drift from their authoritative line amounts. This private demonstration finds two mismatches, retains empty orders and accepts valid credits. It checks decimal range before a private repair and explains why concurrency needs separate proof.
DATE_BUCKET: Align 15-Minute Windows With an Origin
DATE_BUCKET uses an origin to align reporting windows. Keep width, unit and origin explicit while checking timestamps around each boundary.
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.