Years ago when I switched from Windows to Mac, people have told me regularily that I’m crazy. How can I be that stupid to work on MacOS when I’m dependent on SQL Server? In my case it wasn’t that terrible, because my main work is about content creation (writing blog postings, articles, presentations, training videos) …
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. …
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.
