Thanks Bill. That's exactly what I was looking for. Sorry for the repost.

Thanks Perry.

That script worked was perfect.

I plan on leaving between 20% and 25% free space in the file. Should be a good buffer to prevent file growth.

Thanks Michael.

I verified that the vast majority of the tables, including the larger ones and ones most heavily used, have clustered indexes on the primary key columns, so I should...

Ah, that makes sense. Thanks.

I'm gathering index sizes now. With over 500 tables it will take some time.

We do have a test database but we don't have direct access to...

Thanks GSquared.

In my case tempdb is on the same disk, so will sorting in tempdb still help?

Also, do I actually need to worry about about the indexes taking...