SQL Server 2008 introduced the Filtered Indexes. In my current organization, I am taking many interviews of Database Developers and Database Administrators. Most of the people don’t know about the Filtered Indexes, so here, I would like to share a small note about Filtered Indexes and how it improves the query performance. The Filtered Indexes … Continue reading SQL Server: Filtered Indexes – Improved the query performance