Without fail, when I am asked to look at indexes for a customer, I see duplicate and overlapping indexes. While you may think this is not a big deal, (more indexes are better, right?) there are many performance implications. My latest article on SQL Authority shows what these indexes look like and how to clean them up.
-
Recent Posts
- Why I Hate GUIDs 2017/04/05
- What is a Microsoft MVP? 2017/03/01
- Data Types in SSRS Mobile Reports Category Charts 2017/02/26
- T-SQL Puzzler 2017/02/20
- New Pluralsight Course on Mobile Reports is Live! 2017/01/30
Categories
- Database Administration (4)
- High Availability (1)
- Internals (1)
- Life in IT (23)
- Security (1)
- SQL Server 2016 (3)
- SQL Server Administration (4)
- SSIS (6)
- SSRS (6)
- T-SQL (10)
- T-SQL Window Functions (11)
- Uncategorized (16)
