What Else Can Indexes Do

Explore advanced indexing techniques for SQL Server in this comprehensive conference talk. Dive deep into practical applications of indexes beyond basic technical knowledge. Learn how queries utilize indexes and identify warning signs that indicate indexing problems. Examine query plan elements like memory grants, spools, and lookups to optimize performance. Discover how indexes can improve locking strategies. Gain insights on addressing real indexing issues rather than focusing solely on fragmentation. Benefit from Erik Darling's expertise as he shares his experience arguing with the Optimizer and contributing to the First Responder Kit.