Welcome to MSDN Blogs Sign in | Join | Help

November 2009 - Posts

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
Thursday, November 19, 2009 9:28 AM

SQL Server Modeling Services announcement

The code name “Oslo” repository now has the official name “SQL Server Modeling Services”. SQL Server Modeling Services will be a SQL Server workload like SQL Server Reporting Services.
Posted by AnthonyBloesch | 0 Comments
Monday, November 09, 2009 12:21 PM

Paging SQL Server result sets

Paging through SQL Server result sets is an approach for reducing the network and client resources used to display large result sets. Here is a discussion of the merits of three approaches including their relative performance.
Posted by AnthonyBloesch | 0 Comments
 
Page view tracker