Where SQL Server does store the data of DMVs?

One of the questions that I get over and over again is about where SQL Server stores the data that is returned by the various Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs). Many people think that this type of data is stored somewhere within a system database like ...

Read more

My upcoming speaking schedule

“Hot town, summer in the city. Back of my neck getting dirty and gritty. Been down, isn’t it a pity. Doesn’t seem to be a shadow in the city. All around, people looking half dead…” It’s hot, very hot here in Vienna! For me it’s always time to cool down ...

Read more

Composite Non-Clustered Indexes – does the Column Order matter?

When I talk about indexes, people always ask me if the sorting order of the columns in a composite Non-Clustered Index matters? The short answer is always “It depends”. Let’s have a look on it why “it depends”.. Singleton Lookups When you have queries which perform Singleton Lookups on your ...

Read more

999 Non-Clustered Indexes on a Table – a good idea?

Every index in SQL Server can improve your query performance, if the Query Optimizer chooses the index in the execution plan for data retrieval. But on the other hand every index will also hurt your performance, because the index has to be maintained during INSERT, UPDATE, and DELETE operations. Therefore ...

Read more

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top