If you have the space somewhere else, just restore it to a development server and then DTS the objects back over.

I meant to say:

You probably need to run UPDATEUSAGE on all your tables to recover the free space.

I always UPDATESTATS and UPDATEUSAGE after every TRUNCATE

You probably need to run UPDATEUSAGE on all your tables.

I like Visio. I haven't used Visio 2007, but I hope that they decreased the install size. I'm not talking about just Visio. When I installed it...

I keep a good eye on my database sizes. I'm lucky in the fact that I only have to manage 4 servers, 2 in production. I have about...

I wasn't modifying the old table. I was copying to the new table with all varchar. I know that I could have done the trimming as I copied,...

Yes, I assumed that "empty" meant no NULLs. I assumed this because I had marked all the columns as NOT NULL.

It wasn't just the trimming that worked. That...

As always, I appreciate any help. I was just trying to summarize previous posts.

ha ha. Good one.

Out of the 60 SN** columns, only the first 10 are being used right now. The data in the table only goes back...

As I said -

Most of the time the SN** columns are blank, hence they will be smaller than the length of the column

I have already...

Yea, I also try to copy the whole post before I hit Post Reply. Sometimes I forget. Seems that it messes up everytime I write a long post...

Ok, I'm getting a little irritated with this forum. Why is it that if you take too long to write your post, when you try to post it clears...

Thank you for your posts, but I did not fail to mention the data for SN60_NAME:

I checked SN60_NAME and it contained nothing in any of the rows. (I guess it's...

I setup a clustered index on the table and did a DBCC INDEXDEFRAG on the table and no change in size.

The output said that zero pages were removed.

As I said before I have tried this with NULL and NOT NULL columns and the size didn't change.

As I said before that the data in the repeated...