I'm not sure if this is what your after but I found this snip out there somewhere onetime and use it all over.  Better performance that the convert.

Select

-- Standard date...

I think sp_spaceused with the table names, then extimating total size of deletion will be the most accurate way.  That will include the index space that is being saved also. ...

I would also like to see the query run with the following set and see what it says.

set statistics io on

set statistics time on

It will give you the io on...

If performance is your problem as opposed to space, I would look at partitioning the table.  Books online has a good deal of information about this, and from what I...

What is the purpose of this.  The data is always stored with the clustered index.  Any subsequent index can be stored elsewhere on disk and will only contain the key...

Great idea Sergiy.

DDL is not affected by triggers. 

Tom

For truncate and drop you would have to be in the dbo role or sa role.  Just take everyone out of that and grant them the correct permissions on the...

There shouldn't be.  What ever reorganization that had happened up to the point of cancel is kept.

Tom

You should be able to terminate without a problem.  I have done it many times without any problems.

Tom

I have had to put index hints in on occassion.  The reason being what other data elements I was bringing back. Bookmark lookups are very expensive to the optimizer, so when...

Not knowing anything about the application I can't say whether all of the indexes are needed or not.  I can say that I have put indexes on fields that are...

If the size of the backup files are growing that large, than you are not initing the device when you run the next backup.  That is, you have multiple backups...

Yes, there is value to having an index on a view even if the underlying object has no index on it.  The view is materialized meaning anything using that view...

Since I had no original query to modify, it's hard for me to quess what exactly needed to be changed to do this.  As stated earlier in the thread, if...