Just a small thing.Why do you have a fill factor of 80 for increasing identity field?Shouldnt it be 100%?
GulliMeel
Finding top n Worst Performing queries[/url]
Improve the performance of Merge Join(special case)
How to Post Performance Problem -Gail Shaw[/url]