Category Archives: Indexing

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 [...]