Thanks, I just wanted to validate that. My understanding of clustered indexes was partially in error.

--scott

Well look what I started. I appreciate everyone's input. Unfortunately we won't have time to test any of these solutions soon. I will try and update if we have any...

we'll give that a shot.

many thanks

then do we just need to lower the initial size of the primary file and restart sql services to gain the space back?

--Scott

I just assumed (you what that does :)) that moving tables to another filegroup, located on another drive would logically free up space on the PRIMARY. This didn't seem like...