Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » hash index » SQL Server   (RSS)
Monday, November 23, 2009 10:01 AM

Implementing uniqueness constraints on large columns

SQL Server uniqueness constraints may not be aver columns larger than 900 bytes. Here is how to implement uniqueness constraints over larger columns with hash indexes.
Posted by AnthonyBloesch | 0 Comments
Attachment(s): Large uniqueness constraints.docx
Wednesday, February 04, 2009 9:13 AM

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.
Posted by AnthonyBloesch | 1 Comments
Attachment(s): BigUniqueConstraint.sql
 
Page view tracker