Echoes from the field 1: Should SQL Server automatically index foreign key constraints?
We spend a lot of time doing performance tuning work for clients. Inappropriate indexing strategy is often high on the list of issues that we identify. Most of these issues can’t be fixed by SQL Server itself and require a detailed understanding of both how the tables are structured and how they are accessed.
However, there is one very common problem however that I believe SQL Server could assist with.
2025-10-21