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.
Continue Reading »Sep 262013
Sep 242013
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.
Continue Reading »Sep 182013
Joe Sack (@josephsack) looks into some new locking behavior, involving rebuilds and partition switching, available in SQL Server 2014.
Continue Reading »Sep 132013
Joe Sack (@josephsack) takes a look at how online index operations have been improved to take advantage of parallelism in SQL Server 2014.
Continue Reading »Sep 102013
Erin Stellato (@erinstellato) of SQLskills discusses partitioning and explains how it is not always a magic turbo button for improving query performance.
Continue Reading »Sep 052013
Aaron Bertrand (@AaronBertrand) investigates a case where two different methods of deriving an inline constant can lead to very different cardinality estimates.
Continue Reading »