data-konzept

'SQL Server has tools that suggest indexes– and they’ll even auto-create the indexes for you. I’m not a huge fan of these tools because they’ve got some notable flaws: they lead to creating more indexes than you need, and they aren’t super smart about the indexes they recommend.

Two queries that could use some index help

I’m using the free BabbyNames sample database (small version). All the code in this example is also available in a gist for easy access.'...

https://sqlworkbooks.com/2017/03/overindexing-missing-index-dmvs-and-the-database-tuning-advisor/