Anthony Bloesch's Web Log

A WebLog about SQL Server development.

Browse by Tags

Tagged Content List
  • Blog Post: Large tuple uniqueness constraints in SQL Server

    SQL Server 2008 limits unique constraints to 900 bytes of data per tuple. Here is a technique for enforcing uniqueness over larger tuple sizes. In many cases, the technique is more efficient than SQL Server’s unique constraints and can be used for performance critical cases. Hash index based implementation...
Page 1 of 1 (1 items)