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.
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.
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:...
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)...
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...
Tip : Generating Random Numbers in SQL Server Without Collisions
I investigate a case where two different methods of deriving an inline constant can lead to very different cardinality estimates.