Mike, as mentioned in other posts (and w/o trying to convert you, just trying to help with your legacy headache), one common mistake when using GUIDs is to cluster using only the GUID PK (ie, the cluster and PK are the same index). An easy solution to avoid many of the problems you mention is to just add a creation datetime field before the GUID field, and cluster on it (while the PK is still the GUID by itself). Mosttimes, this gives you the best of both worlds. The main drawbacks are that your need a creation datetime field (which is typically a non-issue when you're compliance minded) and that your cluster index key will require more space, and all indexes will be slighlty larger (which is not that much when you consider that you're already using a GUID). However, IMO the benefits are well worth it...