Use temporal tables to retain earlier row versions, query a past state, and plan history storage without confusing version history with user auditing.
SQL SERVER – Quick Note about JOIN – Common Questions and Simple Answers
A quick note about JOIN for T-SQL Tuesday: common questions I get in my office hours, answered simply, like which join method is better.
Growing varchar Updates: How Longer Values Split Pages
A varchar column costs almost nothing while it is empty and a lot once people fill it in. Here is the page count before and after, and what a rebuild recovers.
How to Read a SQL Server Execution Plan
An execution plan is SQL Server showing its working. Read it inside out, learn the six operators you actually meet, ignore the cost percentages, and compare estimated rows with actual rows instead.
FULL JOIN: Preserve Unmatched Rows on Both Sides
FULL JOIN preserves both source sides. Keep identifiers visible while reviewing ordinary equality, unmatched rows and later filters.
SQL_VARIANT_PROPERTY: Inspect the Base Type
SQL_VARIANT_PROPERTY exposes a variant’s BaseType. Compare numeric, date, string and binary inputs with their stored base types intact.
SQL SERVER – Denali – DMV – sys.dm_os_windows_info – Information about Operating System
A quick look at sys.dm_os_windows_info, the new Denali DMV that returns information about the Windows operating system, with an example query.