Indexing

SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability Groups

04/17/2023 04/17/2023 / By Klaus Aschenbrenner / AlwaysOn, Indexing, SQLServer / Leave a Comment

On May 16, 2023 and on June 15, 2023 I will run two SQLpassion Live Trainings about SQL Server Query Tuning Strategies and SQL Server Availability Groups. In the training about SQL Server Query Tuning Strategies I will cover the following areas: Index Tuning Strategies Search Arguments Bookmark Lookup Operations Tipping Point Index Intersection Filtered …

SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability Groups + read more

SQLpassion Live Training about SQL Server Query Tuning Fundamentals

03/07/2023 03/07/2023 / By Klaus Aschenbrenner / Indexing, SQLServer / Leave a Comment

On April 4, 2023 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 SQL Server Query Tuning Fundamentals + read more

Filtered Indexes in SQL Server

11/05/2018 11/05/2018 / By Klaus Aschenbrenner / Indexing, SQLServer / 2 Comments

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. …

Filtered Indexes in SQL Server + read more

Indexes on VARCHAR Columns

04/25/2016 04/25/2016 / By Klaus Aschenbrenner / Indexing, SQLServer / Leave a Comment

Years ago I wrote about how SQL Server stores VARCHAR columns in the Navigation Structure of an index. As you might know, the key columns of an index in SQL Server (Clustered Index, Non-Clustered Index) have a size limitation of a maximum of 900 bytes. Imagine now that you want to fool SQL Server, and …

Indexes on VARCHAR Columns + read more

Disabling Clustered Indexes in SQL Server – a really good idea?

04/11/2016 04/11/2016 / By Klaus Aschenbrenner / Indexing, SQLServer / 10 Comments

Last week I taught an internal SQL Server Performance Tuning course to a customer in Switzerland. As usual we had a lot of fun, and at some point an attendee asked me one of the best questions of my life: “Can you disable a Clustered Index?” At first I was really scared about that question, …

Disabling Clustered Indexes in SQL Server – a really good idea? + read more

SQLpassion Performance Tuning Training Plan – Signup