Hi,

Yes, the sizes that show up are correct, and the tables removed do not appear on the list.

We're running SQL 2008 RTM on Win2K3 SP2 Ent R2

Hi,

I physically deleted the data from the database, I.E. ran the DELETE statement on the rows that were no longer relevant, and also dropped the old tables that were renamed.

Thanks,

The app on the server does not use that much resources, the tasks it has to do are relatively mundane.

I also suspect that server was not really set up correctly...

Hi there, me again,

Just another question, the database server is currently running on Windows Server 2003 Enterprise R2 (x86), with SQL 2008 Standard (x86) with SP1.

Would upgrading the server to...

Thanks all.

I'll go into the code a bit more and have a look. I have optimized some of the procs for the reports before, but not all of them, as...

Hi,

Thanks for the reply. When I read about DBCC ShrinkDatabase, I saw an addendum at the bottom of the page that it trashes your indexes, but I was already halfway...

Thanks for the tips guys.

I'll look into it.

I also thought the DB restore took a little long. The new server has 4 partitions (1 = OS, 2 = Log Files,...

Thanks,

Will do.

Hi George,

Thanks, will do. I checked that SSIS Transfer Logins task, but it still requires you to change the password, which defeats the point in my scenario.

Thanks again.

I have two regrets about the career path I chose and have to live with now. The first, my first job was as a junior (later senior, although never acknowledged,...