Page Free Space

Be Careful with LOBs and OPTION (RECOMPILE) It sometimes makes sense to add OPTION (RECOMPILE) to a query. Typically ...

Advanced T-SQL Tuning: Why Internals Knowledge Matters There is much more to query tuning than reducing logical reads a...

I see no LOBs! Is it possible to see LOB (large object) logical reads from STATISTICS IO output on a table with no LO...

Beware Sneaky Reads with Unique Indexes I saw a question asked recently on the #sqlhelp hash tag: Might SQL Server ...