1.4b Lab 1: Dedupe and Eliminate – Brent Does It

Armed with nothing but sp_BlitzIndex and my wits – okay, well, sp_BlitzIndex anyway – watch as I tackle a wildly over-indexed copy of the Stack Overflow database. I’ll tackle the D.E. portions of the D.E.A.T.H. method. Sample Answers Transact-SQL EXEC dbo.sp_BlitzIndex @DatabaseName=’StackOverflow’, @SchemaName=’dbo’, @TableName=’Posts’; /* Dropping this because it’s a duplicate of IX_AcceptedAnswerId: */ DROP…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM or Mastering Index Tuning, or log in if you already shelled out the cash.

Armed with nothing but sp_BlitzIndex and my wits – okay, well, sp_BlitzIndex anyway – watch as I tackle a wildly over-indexed copy of the Stack Overflow database. I’ll tackle the D.E. portions of the D.E.A.T.H. method. Sample Answers Transact-SQL EXEC dbo.sp_BlitzIndex @DatabaseName='StackOverflow', @SchemaName='dbo', @TableName='Posts'; /* Dropping this because it's a duplicate of IX_AcceptedAnswerId: */ DROP...
To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM or Mastering Index Tuning, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}