THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Browse by Tags

All Tags » SQL » Database Programming   (RSS)
  • Performance of inserts and IGNORE_DUP_KEY

    If your data has a small percentage of duplicates, then IGNORE_DUP_KEY may speed up your inserts. For larger amounts of duplicates, IGNORE_DUP_KEY may slow them down significantly. I set up two tables, stripping down all the irrelevant details, as follows:   CREATE TABLE t1(n INT NOT NULL PRIMARY KEY) GO CREATE TABLE ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on July 30, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement