Aaron Bertrand (@AaronBertrand) shows some tricks for getting row counts efficiently, and explains why an accurate row count for a large table is a pipe dream.
Continue Reading »Oct 302014
Oct 202014
Paul Randal (@PaulRandal talks about Page Life Expectancy – what it is, why fixed thresholds are meaningless, when it matters, and what you can do about it – in this latest installment of his "knee-jerk troubleshooting" series.
Continue Reading »Oct 172014
Aaron Bertrand (@AaronBertrand) offers his thoughts on the latest title from Benjamin Nevarez (@BenjaminNevarez): Microsoft SQL Server 2014 Query Tuning & Optimization.
Continue Reading »Oct 152014
Aaron Bertrand (@AaronBertrand) demonstrates an affordable approach to readable secondaries, without the need for Availability Groups and all the licensing costs involved with Enterprise Edition and Software Assurance.
Continue Reading »Oct 022014
Paul White (@SQL_Kiwi) demonstrates performance tuning a SQL Server execution plan as a whole, instead of honing in too narrowly on individual operators.
Continue Reading »