How I Use sp_BlitzIndex To Find Indexing Problems In SQL Server Databases

If you like what you see here, you'll love my advanced performance tuning training:

[BrusyurSoksow]

(Foolish) individuals often think that DBAs are these nerds that spend all the day being eager about pointing and clicking on things on triple screens.
When people say that to me at parties these days I just say 'yeah, but have you seen that guy Erik Darling on Youtube?' and they fall silent.
I salute your contribution to making the learning things part of my job fun and focussed.

[Garstor]

I really hope that you crocheted something after uploading this.

Good stuff! I usually run BlitzIndex with @TableName and @Mode = 0. Now, I am going to try the less granular options seen here. Thanks!

[toshaikzubair]

Super!!!

Could please explain including fill factor and pad index in highly workload environment
with explains and page analysis as well??

[somusomesh]

Is there way we can know how old the last seek/last scan results are? Like if an index’s last scan says NULL, does it mean it wasn’t scanned in the last week, two weeks? I was thinking the results are from the last sql server restart but not sure.

[hentan]

Good evening. Interesting video, i want to ask about deleting indexes. Which strategy of deleting are best for you? Sorry for mistakes, haven't many practice with English)