Why are Missing Index Hints Missing
This blog post first appeared on SQLMaestros. Let’s understand a few reasons why SQL Server (sometimes) does not show missing index hints. We are using AdventureWorks2016 database for the demo. Let’s make a copy of Sales.Customer table as Sales.CustomerDup SELECT * INTO sales.customerdup FROM sales.customer Before jumping into the actual query, have a look at [...]