Putting Clustered Indexes On Huge Heap Tables
I’ve recently been working with a company that has some relatively large tables stored as heaps. Adding clustered indexes to a few of these tables has been relatively difficult, as they’re very active and, for reasons that I don’t need to get into here, we have very limited drive space. They have SQL Server Enterprise Edition, which allows us to add… (read more)