Results 1 to 2 of 2

Thread: New to SQL Server

  1. 01-15-2003, 12:41 PM #1
    Michele Miller
    Michele Miller is offline Registered User
    Join Date
    Jan 2003
    Location
    Tennessee
    Posts
    1

    New to SQL Server

    We're running SQL Server 7 with OTG (imaging) software, trying to convert a column size on a table with approximately 28million rows. This process has been running for 135 hours. We feel the culprit making it run so long is transaction logging?, and we need to know if there is any way to dynamically turn it off, truncate it, or anything to improve this performance. It appears to be getting slower as time goes on, as it only inserted 4.5 million rows in a 24 hour period. Help!
    Reply With Quote Reply With Quote
  2. 01-15-2003, 02:58 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can't disable transaction logging. Other option is to BCP out your table, recreate the table with new column definition, change database recovery model to BULK LOAD, then import data using bcp or BULK INSERT, change the recovery model to full and take a full backup.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules