Colin,

I believe you are pretty much right on on all your points. Thanks

Mohammed,

Thanks for your input !

Yesterday, when usage was low for this application, there was about 9 tables of any size (2-35GB) and all but one had no clustered index. I...

Thanks Mohammed. Will do some defraging/re-indexing of the indexes this weekend (slow time for production). Will also create a temp clustered index on an appropriate field(s) to get the data...