SQL Server Tipping Games – Why Non-Clustered Indexes are just ignored!
Almost everytime when I’m doing SQL Server consulting engagements, DBAs are showing me queries and their Execution Plans, where SQL Server is just ignoring a good defined Non-Clustered Index. Imagine for example the following table and index definition: CREATE TABLE Customers ( CustomerID INT NOT NULL, CustomerName CHAR(100) NOT NULL, CustomerAddress CHAR(100) NOT NULL, Comments …
SQL Server Tipping Games – Why Non-Clustered Indexes are just ignored! + read more
