Performance, performance, performance. While performance in SQL Server can be achieved with code improvement and proper infrastructure maintenance, both tasks require an effort. Code reviews and deep index analysis would take time, but sometimes the obvious is right in front of you. Let’s talk about HEAP tables, aka tables with no clustered indexes that somebody (hopefully not you) left you to maintain and use.
I’m in no way an expert on indexes, but when I think about tables and indexes, I always draw a parallel to books.
Virtually all books have a table of contents (TOC) at the