Over the past 25 years, I’ve worked with SQL Server in all kinds of environments: startups, mid-size companies, and global enterprises. And no matter the industry or infrastructure, one thing is always true: When SQL Server slows down, everything slows down! Reports take forever. Blocking brings processes to a halt. Deadlocks frustrate both users and …
Why I Created the SQL Rescue Sprint – And How It Works + read more
In today’s blog posting I want to talk about Heap Tables in SQL Server. Heap tables are tables without a Clustered Index. A table in SQL Server can have a Clustered Index, then it’s called a Clustered Table, and without a Clustered Index, it’s called a heap table. In a heap table, the data is …
Today I’m talking about limitations that you have with data pages, and why there are restrictions that you will love, while you will hate other restrictions. As you learned, a data page is always 8kb large, and you can store 8060 bytes of data on it. And the size of your records dictates how many …
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 …
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 …
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.
