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.
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.
Live Plans for Running Queries With sys.dm_exec_query_statistics_xml
Read sys.dm_exec_query_statistics_xml for live plans, compare profile counts with estimates, and interpret partial progress carefully.