Agreed but every poster needs to evaluate the information provided and implement for their environment and company as appropriate.

IMHO, someone else might see this post in the future and use...

I have to agree with Krishna's points.

Looking at your transaction log backup schedule and recovery model should be your starting point.

David

How frequently are you running log backups? The transaction being long enough so as to require the tlogto grow just doesn't sound right. Trans that long should...

The select * into method will only create the table structure not any indexes or primary keys. Tables without indexes are going to slow. That is the first...

Are you running the two test back to back? The second run sounds like it is benefiting from all the data being in the buffer pool (aka...

Thanks for everyone's ideas and input. For my purpose I'm going to call this thread closed.

Take care,

David

Rudy

I appreciate the direction you are taking this but this server configuration is rock solid. The server is not experiencing any obvious signs of a memory bottleneck. ...

Enterprise.

Jeff

I stand corrected on the clustered index point but the space used by the fragmentation versus the data deleted shouldn't be that significant?

David

Hmmm, I must have mis-interpeted this post. Space isn't allocated to tables in Sql Server it is allocated to the database. If you deleted 8000 objects...

USE master

go

DBCC SHRINKDATABASE('your_database_name_here', NOTRUNCATE)

go

DBCC SHRINKDATABASE('your_database_name_here', TRUNCATEONLY)

go

This command will shrink the database and should be run off hours. As always when making a change to adatabase have a backup you...

32 bit and awe is enabled. The server configuration is solid, I'm confident of that.

Win2003 Sp1, Sql 2000 8.00.2187 12 gig of Ram, With 10 gig set as the max, no min is set.

I strongly doubt the server is memory hungry. ...

Run this line of Sql and post the results.

Use your_database_name_here

go

exec sp_spaceused

go

Jack suggestion was implemented and is working.

Thanks