Paul White (@SQL_Kiwi) dives deep into new execution plan information introduced in SQL Server 2012; specifically, thread reservation and usage information for parallel plans.
Glenn Berry (@GlennAlanBerry) of SQLskills.com talks about memory limits on certain versions and editions of SQL Server, and ways to determine the optimal amount of memory to put in your servers.
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.
The SQLintersection conference is happening in Las Vegas at the end of October. Find out why we're excited to go and how you can save $100 off the conference admission fee.
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) investigates a case where two different methods of deriving an inline constant can lead to very different cardinality estimates.
