SQL Table stored as a Heap - the dangers within
- by MikeD
Nearly all of the time I create a table, I include a primary key, and often that PK is implemented as a clustered index. Those two don't always have to go together, but in my world they almost always do.
On a recent project, I was working on a data warehouse and a set of SSIS packages to import data from an OLTP database into my data warehouse.…