I saw Brent Ozar on Youtube Performance Tuning and going back to the stone-ages using @AI = 2 in sp_BlitzIndex, copy/edit/paste and again paste/copy/edit..
Use your precious time and save money by using a smart app and keep the focus on the ultimate goal.. make users happy.
EXEC dbo.sp_BlitzIndex @DatabaseName= 'StackOverflow2013'
, @SchemaName='dbo'
, @TableName= 'Badges'
, @AI = 2
Make sure to get a Fully Optimized Plan, not a trivial one, you otherwise do not get missing index hints.
Use the App and transform the AI promt to an Index Solution, not interaction.
If it goes wrong… you didn’t do this right.. it was the Robot failing again…
Rerun the Query and thanks to Erik Darlings ( Free SQL Server Performance Monitoring | Darling Data ) Performance Studio and of course Brent Ozar ( Brent Ozar Unlimited – SQL Server Consulting and Training ) for all his work.
Heel gaaf!