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 constraint must also be subject to a not NULL constraint, unless the DBMS implements an optional… 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 maintenance vs. its… Read more