The Curious Consultant
Menu Close
  • Home
  • Here’s everything!
    • C#
    • SQL
    • General
    • Code
      • C# Code
      • JavaScript/TypeScript Code
      • SQL Code
    • Tips and Techniques
      • C# Tips and Techniques
      • Nintex Form Tips and Techniques
  • About Dave
  • My Blogs
  • Contact Me Anytime!

Not Exists

10

SQL: Fastest way to insert new records where one doesn’t already exist

Posted on July 21, 2015 by David Lozinski
SQL Code

Fastest way to insert new records where one doesn’t already exist SQL Developers come across this scenario quite often – having to insert records into a table where a record doesn’t already exist. The age-old technique and I suspect most… Continue Reading →

SQL Except, Exists, insert, Join, Left Join, Merge, Not Exists, sql

Subscribe to be notified of new posts:

Loading

Most Popular Last 30 Days

  • SQL: Fastest way to insert new records where one… (986)
  • C# .Net: Fastest Way to Read Text Files (943)
  • SQL: LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX (440)
  • C# .Net: Fastest Way to check if a string occurs… (371)
  • SQL: Fastest way to compare multiple column values (362)

Categories

Latest Comments:

  • Utkarsh Kapadia on C#: Dictionary Vs ConcurrentDictionary
  • Mike H on C#: Dictionary Vs ConcurrentDictionary
  • Utkarsh Kapadia on C#: Dictionary Vs ConcurrentDictionary
  • danzar on Length Vs Count Vs Initialized Variable in C#
  • 5Arete23 on Fastest Collection for String Lookups in C# .Net

Recent Posts

  • Does How You Access Class Properties Make A Difference?
  • Things I do to increase Windows drive performance
  • Massive SQL Date Time Cheat Sheet
  • Division Vs Multiplication Equivalent
  • Does caching calculated loop indexes make a difference?

Everything Else!

Here's Everything if you're trying to find a post, missed some, or just want to see, well, everything. :-)
© 2023 The Curious Consultant. All rights reserved.
Hiero by aThemes