A few months ago I have prepared the physical hardware my VMware vSphere based Home Lab for the migration from 6.5 to 6.7. And last Thursday it was finally the big day: I’ve done the migration from vSphere 6.5 to 6.7. In this blog posting I want to describe the necessary steps, and in which …
As you know I’m offering through the SQLpassion Online Academy Live Training sessions, and also recorded versions of these trainings for your immediate access. I’m quite happy today to announce that I’m providing you for the following available online trainings a discount over the next 30 days: Design, Deploy, and Optimize SQL Server on VMware …
Do you have ever heard about an “Event-Less” Extended Event Session? What is the idea about it? Why do you want to have an Extended Event Session without any events? Let’s talk about it… Event Less When you create an Extended Event Session in SQL Server, the definition of the Event Session specifies which Events, …
In today’s blog posting I want to talk about a very interesting topic: in which execution state is a query waiting on “something”? By definition we can all agree that a query always waits in the SUSPENDED state. But this behavior is not really true. So let’s talk about it… Query Life Cycle Every time …
Does a Query always wait in the SUSPENDED State? + read more
Today’s blog posting is a quite interesting one, because I want to show you a concrete example where in an Actual Execution Plan the Actual Number of Rows are WRONG! Yes, you have read correctly: I’m talking here about the Actual Number of Rows, and not about the Estimated Number of Rows, which are always …
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.
