A few weeks ago I got quite an interesting question from a weblog reader: does a RECONFIGURE statement flush the Plan Cache? Normally my answer to this question is a simple Yes, but as we have sometimes found out together the real answer is an “it depends”. Let’s have a look at it, and why …
Does a RECONFIGURE statement flush the Plan Cache? + read more
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 the master database. But this …
“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 (from work!), relax, and work …
Today I have uploaded SQL Server Quickie #37 to YouTube. This time I’m talking about Inner Joins in SQL Server. Thanks for your time, -Klaus
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 tables, the sorting order of …
Composite Non-Clustered Indexes – does the Column Order matter? + read more
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
