Generate random integers without collisions
I discuss a common requirement, generating random numbers to serve as surrogate keys, and show how you can avoid the incremental cost of preventing collisions.
Monthly Archive: September 2013
SQL Server 2012 Service Pack 1 Cumulative Update #6 is available!
The SQL Server team has released CU #6 for Service Pack 1. KB article: KB #2874879 Build # is 11.0.3381 This build has 23 fixes by my count. The most interesting (to me) are:...
September 2013 Cumulative Update for SQL Server 2008 SP3
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update #13 Build # 10.00.5846 KB Article: KB #2880350 2 fixes Relevant for builds 10.00.5500 -> 10.00.5845 NOT for SQL Server 2008 R2 (10.50.xxxx)...
Join us in Las Vegas for SQLintersection and save $100
The SQLintersection conference is taking place at the MGM Grand in Las Vegas, the week of Hallowe'en (October 27th – 31st). While much of the hubbub this time of year surrounds the PASS Global...
Generating Random Numbers in SQL Server Without Collisions
Tip : Generating Random Numbers in SQL Server Without Collisions
Performance Surprises and Assumptions : DATEDIFF
I investigate a case where two different methods of deriving an inline constant can lead to very different cardinality estimates.