When you might not want to use a clustered index
In some scenarios, it might be beneficial to not have a clustered index on a table. E.T.L. staging tables is one scenario that you might not want to have a clustered index. We’re loading into a data warehouse a few times a day, and that could be hundreds of thousands of records at a time,... » read more