Benjamin Nevarez (@BenjaminNevarez) gives us some insight into the new cardinality estimator in SQL Server 2014 – both how it works as well as how to keep the functionality of the current version of the estimator.
Erin Stellato (@erinstellato) of SQLskills discusses partitioning and explains how it is not always a magic turbo button for improving query performance.
Aaron Bertrand (@AaronBertrand) of SQL Sentry discusses a case where assumptions can lead to a poorly-performing query and where exploring other options can pay off.
Erin Stellato (@erinstellato) talks about the implications of holding onto data, beyond its reasonable lifetime, in monolithic, single-partition tables.
Aaron Bertrand (@AaronBertrand) reflects on the presentation he gave during the PASS Performance VC Summer Performance Palooza 2013 on June 27th, including a wealth of responses to Q & A.
