Indexing SQL Server Queries For Performance: Missing Index Requests Are Bad And Dumb

[@rasser44]

Tak!

[@marancibia1971]

Great video! I've seen missing index requests that serve no purpose, but after watching this video I'm convinced that I shouldn't bother even paying attention to them.

[@douglascoats7081]

Many moons ago at my very first dev job, my first mentor basically wrapped my knuckles with a ruler when she saw me right click a missing index suggestion. It was nice to have someone early on in my career teach me "you cant always trust microsoft" with things like this. Nice content by the way :)

[@douglascoats7081]

I know i can google this but can you disable index suggestions?

[@ErikDarlingData]

Trace flag 2330 will disable them, but also has other effects.

[@caparn100]

Very impressive! It would be easier to follow if you kept the screen focused on the SQL for a bit longer, rather than jumping quickly between different sections.

[@ErikDarlingData]

I do have to keep things moving to keep the videos a somewhat reasonable length. You can of course pause where necessary.