Last week Brent Ozar published a blog post, where he talked about how choose a successful topic for a weblog. He gave 3 different examples of success and even failure: Jonathan Kehayias, who has established his name with his famous Extended Event series Niko Neugebauer, the well-known guy on ColumnStore Indexes Klaus Aschenbrenner, who wrote …
Writing a book on Service Broker – a wise decision? + read more
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 …
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.
