SQL Server Quickie #38 – Outer Joins
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
Does a RECONFIGURE statement flush the Plan Cache?
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
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 the master database. But this …
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 (from work!), relax, and work …
SQL Server Quickie #37 – Inner Joins
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