January 5, 2012 at 12:21 pm
I have a server, the ram is limited to 1GB. I'm sure this would effect the operation.
I'm trying to truncate a table with about 1million records. The truncate table statement ran for about an hour before I canceled it. I tried to create a new table, sp_RENAME to rename the old table, then rename the new. Tried to drop the table, then rename the new table.
All of these operations are taking really long times. Is this because the low ram allocation? Is there a faster method?
Thanks
nvm Resolved: Exclusive access to table
January 5, 2012 at 1:08 pm
YEah 1gb is going to be very hard to work with. However, creating a table, dropping a table, these operations should be fairly quick. You're probably just hitting resource contention. Check for blocking while running your operations. Get more memory.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply