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.
