Welcome to MSDN Blogs Sign in | Join | Help

December 2005 - Posts

Achieving Selective Uniqueness in SQL Server Tables
SQL Server development group is repeatedly getting questions, suggestions and requests related to supporting unique indexes allowing multiple NULLs in SQL Server. The SQL Standard requires that a column—or a set of columns—which is subject to a UNIQUE Read More...
How can SQL Server 2005 help me evaluate and manage indexes?
SQLCAT Blog: Question: How can SQL Server 2005 help me evaluate and manage indexes? (1) How can I find out whether my indexes are useful? How are they used? (2) Do I have any tables or indexes that are not used (or rarely) (3) What is the cost of index Read More...
Page view tracker