US and Worldwide: +1 (866) 660-7555
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: How to swap JTDS driver for MSFT driver for SQL Server?

  1. #11
    Join Date
    Feb 2008
    Posts
    216

    Default

    This just in. Don't use the truncate tables job entry either. Same deal. I guess it will have to be an actual sql statement.

  2. #12
    Join Date
    Apr 2008
    Posts
    2,467

    Default

    I thought that was how the option was intended to work...

    Truncate the table before insert = Delete from <table>; Insert into <table> values (?,?,...)

  3. #13
    Join Date
    Feb 2008
    Posts
    216

    Default

    Quote Originally Posted by gutlez View Post
    I thought that was how the option was intended to work...

    Truncate the table before insert = Delete from <table>; Insert into <table> values (?,?,...)
    I think it depends which connection type you use. I assume since this is a generic database connection it is using the least common denominator. Some databases don't have an actual truncate command. But delete logs everything and truncate does not.

  4. #14
    Join Date
    Mar 2010
    Posts
    159

    Default

    Delete from can generate some huge rollback segments and take a while if many rows relative to a truncate.

Tags for this 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
  •