Andrew Gothard (10/3/2008)
* Well, no rules hold fast all the time. Sure someone'll think of a situation where this wouldn't be the case I'm sure
Depends how fast the table changes. If inserts only happen occasionally (an employees table, or something like that), then the main reason for clustering on an ascending key (fragmentation) isn't that applicable.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability