Category Archives: Indexing

This Might Be Useful

In SQL Server 2005 and up, Microsoft provides a set of immensely useful views and functions that let you see how and what the engine is doing. They are colloquially known as the DMVs, ‘Dynamic Management Views’. I cannot stress how useful they are. Here is an example, and a very useful query. This uses the DMVs [...]
Posted in Indexing | 2 Comments