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
- SSRS Azure VM Checklist 2019/12/09
- News from Aunt Kathi 2019/10/29
- May 2019 T-SQL Tuesday #114: Puzzles 2019/05/14
- Celebrating Women in Tech 2019/03/04
- Three Books That Have Influenced My Career 2018/12/03
Categories
- Database Administration (7)
- High Availability (1)
- Internals (1)
- Life in IT (29)
- Security (2)
- SQL Server 2016 (3)
- SQL Server Administration (5)
- SSIS (6)
- SSRS (7)
- T-SQL (10)
- T-SQL Window Functions (12)
- Uncategorized (25)
