An attendee says two sessions run at the same time. Here is how to find every overlapping pair once, and why touching is not a clash.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Finding Queries That Spill With total_spills in Query Stats
Rank total_spills and recent counters, inspect plans, compare Query Store tempdb use, and investigate estimates before increasing grants.
Agent Job Step Retries: Retry Attempts and Retry Interval
Configure Agent retry attempts and minute intervals, inspect retry history, and distinguish transient failures from unsafe replays.
Session State in SQL Server With Memory-Optimized Tables
Store transient session state in memory-optimized SQL Server tables with native reads and writes, expiry checks, and clear durability rules.
Checking Constraints After a Bulk Load With DBCC CHECKCONSTRAINTS
Run DBCC CHECKCONSTRAINTS after a controlled bulk-load bypass, inspect violations, and restore enabled trusted CHECK and foreign-key rules.
Log File Not Shrinking: Read log_reuse_wait_desc First
A log file not shrinking is explained by one column: log_reuse_wait_desc. A demo database reads LOG_BACKUP and ACTIVE_TRANSACTION from it and shows why the first shrink after a log backup can still fail. A table lists the other reasons with the action for each.
Swap Columns – SQL in Sixty Seconds #199
Today we will see a quick video on how to swap columns in SQL Server. It is a widespread request. We will learn that in this video.
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.