Today I want to talk about a specific kind of index in SQL Server: Filtered Indexes, which were introduced back with SQL Server 2008 – so already very long time ago. A Filtered Index is a traditional Non-Clustered Index, which includes a Filter Predicate that restricts the rows that are indexes in that specific index. …
As you might know from my Home Lab setup, I’m a big believer and fan of VMware vSAN, which is a Software-Defined Storage solution. Therefore I want to show you in today’s blog posting a step-by-step guide how you can create a vSAN based vSphere Cluster. For a basic understanding about the inner workings of …
Todays blog posting is a little bit more personal than technical. It seems that I don’t have that much luck this year, because since Sunday evening I have a broken right foot 🙁 I don’t want to go into the details about how it happened, but in the first step it seemed that I have …
In today’s blog posting I want to talk about Query Memory in SQL Server, and want to show you how fast it can degrade the performance of your queries. Before we dive into the details about how SQL Server is managing Query Memory, I want to talk briefly about what Query Memory actually is. Query …
Query Memory Grants and Resource Semaphores in SQL Server + read more
In today’s blog posting I want to give you a brief overview about my upcoming Speaking Schedule, and where you can meet me physically and virtually. From October 8 to 11 I’m speaking at the SQLdays Conference in Erding/Germany (near Munich). I’m giving here 2 full-day workshops and 2 regular sessions about the following topics: …
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.
