Filtered Indexes are a great way to improve performance when your application frequently requests the latest data from a large table. Unlike standard indexes, Filtered indexes only index a subset of the data in the table. This gives you a much smaller index that is faster to query. Today I’m using the AdventureWorksDW2012 database to run all […]
Hi, I'm James Anderson. When I'm not blogging about SQL Server, I do this.