I knew i could count on you smart people!!!! 🙂

A few follow ups---

What is the best way to view fragmentation? Is it sys.dm_db_index_physical_stats??

If it is, what is the key indicator i.e. avg_fragmentation_in_percent

or other? what values would trigger a rebuild?

Michael - you mentioned adding data in the same order as the clustered index. Does that mean my insert statement should be:

INSERT (Field1,Field7,Field8,Field2,Field3...) if Field1,Field7,Field8 is my clustered index??

Again - TY all for the insight.

Peter