Here’s everything!

C#

• Does caching calculated loop indexes make a difference? (8/3/2020)
• Does Parameter Order Make A Difference (6/8/2020)
• Greater Than vs Less Than vs Equals in C# (4/3/2020)
• Length Vs Count Vs Initialized Variable in C# (2/10/2020)
• C#: Ints Vs Stringified-Ints (2/12/2019)
• C# ConvertTo Vs Parse (11/6/2018)
• C#: Dictionary Vs ConcurrentDictionary (2/14/2018)
• C# TryParse Vs Try Catch (11/4/2017)
• C#: Fastest Way To Check Last Character of a String (4/4/2017)
• C#: For Vs ForEach Vs While (5/13/2016)
• C#: Fastest way to TRIM strings (1/9/2016)
• C#: Is It Faster to Preallocate Dictionary Sizes? (1/21/2015)
• Fastest Way to Compare Strings in C# .Net (12/8/2014)
• Fastest Collection for String Lookups in C# .Net (11/2/2014)
• Faster to Trim during or after assignment in C# .Net (9/23/2014)
• C#.Net: The Fastest Way to count substring occurrences in a string (8/16/2014)
• C# .Net: Fastest Way to Clear Collections (6/18/2014)
• C# .Net: Fastest Way to count the number of times a character occurs in a string (4/13/2014)
• C# .Net: Fastest Way to Convert an Int to a String (3/24/2014)
• C# .Net: What is the fastest conditional statement? (2/6/2014)
• C# .Net: Fastest Way to check if a Number is Odd Or Even (1/16/2014)
• C# .Net: Use the Modulus Operator or Alternative? (12/16/2013)
• The Fastest Way to Read and Process Text Files using C# .Net (11/1/2013)
• C# .Net: Fastest Way to Convert a String to an Int (9/28/2013)
• C# .Net: Fastest Way to Read Text Files (8/30/2013)
• C# .Net: Fastest Way to check if a string occurs within a string (8/17/2013)

C# Code

• C#: Read lines from a text file in batches and process in parallel (11/5/2016)
• C#: Azure Blob Storage Manager Class (7/3/2016)
• C#: CSV File Writer Class (3/25/2016)

C# Tips and Techniques

• C# logging data technique (5/1/2018)

JavaScript / TypeScript Code

• JavaScript-TypeScript for Nintex Forms to Validate File Names (8/5/2018)

SQL

• SQL: comparing values IN vs INNER JOIN (9/24/2019)
• SQL: LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX (10/7/2015)
• SQL: Fastest way to insert new records where one doesn’t already exist (7/21/2015)
• Increase SQL Server tempdb Performance (5/10/2015)
• SQL: Fastest way to compare multiple column values (3/3/2015)
• Optimizing SQL Strategies (5/21/2014)

SQL Code

• SQL: get max length of values in every table column (7/11/2017)
• SQL: “Watchdog” loop to start and monitor SQL Agent Jobs (1/16/2017)
• SQL: Rebuild Indexes, Update Statistics, and Shrink Databases on SQL Server (9/12/2016)

Nintex Form Techniques

• Override the Nintex Form Save and Submit Button Behavior (6/4/2019)
• JavaScript-TypeScript for Nintex Forms to Validate File Names (8/5/2018)

General

• Tricky C# and SQL Interview Questions (4/10/2016)