Filtered Index with variable

Filtered Index is a great way to improve your SQL performance and save a vast amount of server resources while processing your big data query. Whenever you have a filtered index you just might find that it’s not used when its columns are compared to a variable. The thing is, SQL Server will always make … Continue reading Filtered Index with variable