← Customer Feedback for Redgate Settings and activity 1 result found Make INSERT statements more efficient using shorter SQL 72 votes Vote Vote Vote Vote We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close 1 vote 2 votes 3 votes Remove votes You have left! (?) (thinking…) 3 comments · SQL Data Compare · Delete… · Admin → How important is this to you? Not at all You must login first! Important You must login first! Critical You must login first! We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close Tim Abell supported this idea · Feb 2, 2015 An error occurred while saving the comment Tim Abell commented · Feb 2, 2015 · Edit… · Delete… I wrote a tool to tidy up the generated files: https://github.com/timabell/sql-insert-trimmer @redgate, if you implement this watch out for the performance cliff! http://stackoverflow.com/a/8640583/10245 would be good to work out the optimal number of value lines depending on the number of columns. Save Submitting...
Tim Abell
supported this idea
·
Tim Abell
supported this idea
·
I wrote a tool to tidy up the generated files: https://github.com/timabell/sql-insert-trimmer
@redgate, if you implement this watch out for the performance cliff! http://stackoverflow.com/a/8640583/10245 would be good to work out the optimal number of value lines depending on the number of columns.