Today I’m talking about Extent Management in SQL Server, because this is a very important topic, especially when you deal with TempDb in SQL Server. On a very high level an extent is just a group of 8 pages of 8kb. An extent is therefore always a chunk of 64kb. SQL Server internally implements 2 …
As you might know, I have written a long time ago a book about Service Broker – a technology within SQL Server that almost nobody is aware of and interested in. But Service Broker provides you an elegant way to implement reliable, distributed, message-based applications directly within the database. One of the hardest things to …
Creating a distributed Service Broker application with Docker + read more
Last week we laid out the foundation for how SQL Server executes queries. I have also already talked here a little bit about pages that are buffers of 8kb. Today we concentrate further on these pages and drill into more detail and what it means from a performance tuning perspective. Pages are the foundation of …
Beginning with today, I want to give you over the next few months a blog post series about the basics of performance tuning in SQL Server. Before we go into the nasty details of performance tuning in SQL Server, I want to lay out today the foundation about how SQL Server executes a query. This …
As we all know there is already a lot of information available about SQL Server related topics in English. But I’m also dealing more and more with customers who want to have some materials available in their native language – in that case in German. Therefore, I’m very pleased to announce that I have released today …
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition + read more
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.
