SQLServer

SQLpassion Live Training about SQL Server Availability Groups

09/05/2022 09/05/2022 / By Klaus Aschenbrenner / SQLServer / Leave a Comment

On September 29, 2022 I will run an SQLpassion Live Training about SQL Server Availability Groups. High Availability with previous versions of SQL Server was always complex: you had Clustering, Database Mirroring, Log Shipping, and Replication. Beginning with SQL Server 2012 Microsoft changed everything and introduced a new High Availability technology called Availability Groups. In …

SQLpassion Live Training about SQL Server Availability Groups + read more

SQLpassion Live Training about Query Tuning Fundamentals

04/04/2022 04/04/2022 / By Klaus Aschenbrenner / SQLServer / Leave a Comment

On May 3, 2022 I will run an SQLpassion Live Training about SQL Server Query Tuning Fundamentals. If you have a database driven application which reacts very slowly when the data increases, then you are right in this live training! In this live training you will learn how you can tune SQL Server Queries with …

SQLpassion Live Training about Query Tuning Fundamentals + read more

Heap Tables

03/01/2022 03/01/2022 / By Klaus Aschenbrenner / Performance Tuning, SQLServer / Leave a Comment

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 …

Heap Tables + read more

Data Page Restrictions

02/21/2022 02/21/2022 / By Klaus Aschenbrenner / Performance Tuning, SQLServer / Leave a Comment

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 …

Data Page Restrictions + read more

Extent Management in SQL Server

02/14/2022 02/14/2022 / By Klaus Aschenbrenner / Performance Tuning, SQLServer / Leave a Comment

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 …

Extent Management in SQL Server + read more

SQLpassion Performance Tuning Training Plan – Signup