Aaron Bertrand (@AaronBertrand) discusses a common requirement, generating random numbers to serve as surrogate keys, and shows how you can avoid the incremental cost of preventing collisions.
Aaron Bertrand (@AaronBertrand) investigates a case where two different methods of deriving an inline constant can lead to very different cardinality estimates.
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.
Paul White (@SQL_kiwi) talks about a regression in the optimizer's handling of aggregates against partitioned tables when moving from SQL Server 2005 to SQL Server 2008+.
SentryOne's Aaron Bertrand (@AaronBertrand) discusses a few additional places to get information useful for decisions about creating new indexes that are suggested as "missing" by various tools.
