SQL Server Filtered Index

What is a SQL Server Filtered Index A SQL Server Filtered index is a nonclustered indexes that can be used to increase query performance when selecting records from a table.  This type of index can be especially useful when there are a small count of  distinct values in a column such as gender that can … [Read more…]