The theme for this session is database "indexes".Indexes are one of the technologies you absolutely must understand when ...

Indexes typically improve performance, however if all the columns required by a query are not on the index, some data is obtained from the underlying table via a key lookup. When a ‘large’ amount of ...

As a consultant whose job description includes putting out performance fires, I get to see a lot of problematic queries that can dramatically harm overall server performance and throughput. Wondering ...

A popular performance tuning book gets updated for SQL Server 2025, how does it fare? Ian Stirk takes and in depth look and finds it pretty good. This well-liked SQL Server book examines performance ...