I see it often in the field – sometimes people regularly restart SQL Server! We all hopefully agree that a regular restart of SQL Server isn’t really a good idea. But in today’s blog post I want to dig a little more into the details what the side-effects are when you restart SQL Server on …
Today I have uploaded SQL Server Quickie #38 to YouTube. This time I’m talking about Outer Joins in SQL Server. Thanks for your time, -Klaus
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 …
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.
