Simplest Example

Simplest Example

the essence of the thing

Posts filed under nonclustered

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)