Welcome to MSDN Blogs
Sign in
|
Join
|
Help
Anthony Bloesch's Web Log
A WebLog about the design of the codename "Oslo" repository.
This Blog
Email
Syndication
RSS 2.0
Atom 1.0
Search
Tags
architecture
bugs
connect
Developers
dog-food
equality
Error handling
feedback
forums
fragmentation
hash index
Hierarchies
instead of trigger
Intellisense
keyboard
lifecycle
Microsoft
Microsoft Oslo
Modeling Services
Oslo
paging
refactoring
Repository
row_number
Security
shortcut
SQ Server
SQL
SQL Server
SQL Server Modeling Services
style
top
trailing spaces
Trees
T-SQL
unique
Unique constraint
uniqueness
versioning
view
Windows 7
Archives
November 2009 (3)
April 2009 (2)
March 2009 (2)
February 2009 (3)
January 2009 (3)
December 2008 (2)
November 2007 (1)
February 2006 (1)
October 2005 (3)
September 2005 (7)
Interesting links
Microsoft security guidance
"Oslo" forums
"Oslo" development center
Interesting web logs
Keith Short
Kent Tegels
Kimberly L. Tripp
Steven Clarke
Steve Cook
Stuart Kent
ObjectRoleModeling.com
Browse by Tags
All Tags
»
SQL Server
»
unique
(RSS)
hash index
uniqueness
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
Filed under:
SQL Server
,
hash index
,
unique
,
uniqueness
Attachment(s):
BigUniqueConstraint.sql
