Are you sure the table contains only 7000 rows? Or are you looking at rows that have some value with a where clause?

If there are only 7000 rows, I'm confused...

Data warehouses tend to grow pretty well. Why both to shrink? If you needed 45GB at one point, won't you need it again relatively soon?

If there is a space issue,...

Everyone is replaceable, but not easily replaceable and I'd like to think that most people have value at their jobs. If you treat them as if they are easily replaceable...

Dell had some cheap ones, and you could check eBay for something used.

You can use virtual servers and share the disks that way.

You could use snapshots if you have Enterprise edition, but if you need to restore or something happens you'll lose them.

A better solution would be calculate this stuff and store...

You can write triggers to catch updates and deletes on specific tables if you want.

You can limit SQL using the affinity mask, but AFAIK, this doesn't affect licnensing. If you have 2 CPU sockets filled in the machine you need to license both of...

I'm not sure the diffs help you here in that you would likely fail to the standby, not recover the primary. If you then wanted to fail back, you're have...

It doesn't increase the space, but it does fix any reporting issues from the deletes.

The dev db is never the master. VSS is the master. You start by pulling everything into VCS from the production db, then you deploy to the dev db from...

I would lean towards Gail's note. Likely something just hasn't been updated, but once you've deleted the rows, the space is available for reuse. If you've deleted things, the space...

I'll second Grant's note. We had a db with over 1000 stored procedures, but at any given time we were editing only 10-20 of them.

We never allowed anyone to edit...

We have an eBook in our Books section[/url] on Profiler. Worth reading to understand things, but as Grant mentioned, use a server side trace.

Do you have a proxy set for the job? Or can you execute each statement with the SETUSER clause and see which one might be causing issues? My guess is...

You could argue that when you dbs are TB sized, they might be more valuable and more in need of protection. I just added 4TB to my home network for...