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.

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.