I today’s blog posting I want to talk about Extent Management in SQL Server, because this is a very important topic, especially when it comes to TempDb. 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 …
SQL Server 2016 provides you with a lot of new features and functionality around the ColumnStore index that was introduced back with SQL Server 2012. One of these new features is the ability to create a Filtered Non-Clustered ColumnStore Index on top of a regular Row-Store table. This might sound a bit surprising at first, …
The pain of Real-Time Data Analysis in SQL Server 2016 + read more
It happens very often these days: people contact me because they want some help from me in designing their High Availability solution for SQL Server. There are already a lot of people who are interested in deploying AlwaysOn Availability Groups. And this demand will grow further in the future, because Availability Groups will be part …
How to ruin your High Availability solution by using Virtualization + read more
Today I have uploaded SQL Server Quickie #32 to YouTube. This time I’m talking about the difference between Temp Tables and Table Variables in SQL Server. Thanks for your time, -Klaus
At the beginning of my SQL Server Performance Tuning Workshop I always start by giving a general overview of what happens within SQL Server when we execute a query. Executing a SELECT query is quite simple, but executing a DML statement is more complex, because SQL Server has to change the corresponding page in memory, …
How the CHECKPOINT process deals with uncommitted transactions + 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.
