Indexing

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

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

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

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

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