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!

SQL

0

SQL: comparing values IN vs INNER JOIN

Posted on September 24, 2019 by David Lozinski
SQL Code

IN Vs INNER JOIN Here we will do a quick benchmark on using IN vs INNER JOIN.   This came about when a coworker had to run a one-off SQL statement to see if approximately 3,500 codes (from a supplied… Continue Reading →

SQL IN, INNER JOIN, sql
11

SQL: LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX

Posted on October 7, 2015 by David Lozinski
SQL Code

LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX All too often developers need to query a database table for records which begin and/or end with a certain textual pattern. For instance, find all employees where their first name begins with “DAV”.… Continue Reading →

SQL CHARINDEX, LEFT, LIKE, RIGHT, sql, substring
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
1

Increase SQL Server tempdb Performance

Posted on May 10, 2015 by David Lozinski

Increase SQL Server tempdb Performance In this article I hope to shed light on some very simple ways to increase SQL Server tempdb performance. As an SQL developer, I’ve spent countless hours doing everything I can to optimize tables and… Continue Reading →

SQL performance, SQL Server, tempdb, tricks
8

SQL: Fastest way to compare multiple column values

Posted on March 3, 2015 by David Lozinski
SQL Code

Fastest way to compare multiple column values I was recently working on a project with stored procedures that had a significant amount of column comparisons in a MERGE statement. This was turning into a real performance bottleneck (relatively speaking) as… Continue Reading →

SQL Binary_Checksum, Checksum, Concat, Hashbytes, sql, Stuff
8

Optimizing SQL Strategies

Posted on May 21, 2014 by David Lozinski
SQL

Optimizing SQL Strategies How many of you have come across SQL code that, for whatever reason, wasn’t written as good as it could have been? I’m not talking about going into the inner workings of your database’s engine and milking… Continue Reading →

SQL @Table Vars, #TempTables, optimize, sql, SQL optimizing, strategies

Subscribe to be notified of new posts:

Loading

Most Popular Last 30 Days

  • SQL: Fastest way to insert new records where one… (898)
  • C# .Net: Fastest Way to Read Text Files (855)
  • SQL: LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX (397)
  • C# .Net: Fastest Way to check if a string occurs… (340)
  • SQL: Fastest way to compare multiple column values (328)

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