In SQL Server 2008, you can have what is called a "Filtered Index". What does this mean? An index may be created for a subset of rows in your table. For instance you could create a filtered index for a "state" column if the value is "CA" for California;
Read More...