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.
SQL SERVER – Reasons – Not Able to Shrink the Transaction Log
Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.
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.
Heartbeat Gaps: Finding Missing Check-Ins With LAG
Detect missing check-ins with LAG, report closed heartbeat gaps, and find silent or never-seen sources using an explicit UTC tolerance.