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.
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 Enhancement – sys.dm_exec_query_stats – New Columns
SQL Server Denali adds four new columns to sys.dm_exec_query_stats, like total_rows and last_rows, so you can see how many rows your queries returned.
Stop Chasing Every Seek: When a Table Scan Is the Right Plan
A Clustered Index Scan is not always the problem. Count the reads for a seek with lookups, a scan and the optimizer’s own pick, then see when the seek really wins.







