Capture rows with INSERT EXEC, match result columns, understand nested and multiple-result limits, and choose supported alternatives.
Approximate Percentiles With APPROX_PERCENTILE_CONT
Use APPROX_PERCENTILE_CONT for large response-time summaries, compare exact percentiles, and interpret the documented rank error bound.
Finding Schedule Clashes: Overlapping Sessions per Attendee
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.
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.
Prepared Statements and Plan Reuse From Application Code
Inspect prepared statements, handle lifetimes, parameter types, cached Prepared plans, and the limits of optimize for ad hoc workloads.