Anthony Bloesch's Web Log

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....

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....

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....