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.
SQL SERVER – Denali – DMV – sys.dm_os_volume_stats – Information about operating system volume
The new Denali DMV sys.dm_os_volume_stats shows the operating system volume where each database file is stored, with its total and available space.
Reading the Transaction Log With fn_dblog
fn_dblog can expose transaction-log records during a narrow investigation, but retention and missing user context make it a last resort.
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.
A Shared SEQUENCE for Invoices and Credit Notes in One Range
One sequence, two tables, and an auditor asking about number 8. See where gaps come from, how duplicates sneak in, and where uniqueness should live.










