C#: For Vs ForEach Vs While In this article we’ll benchmark iterating over commonly used collections and data structures with the following loop constructs in C#: For Vs ForEach Vs While. A List of strings needs to be written to… Continue Reading
Tricky C# and SQL Interview Questions for mid-to-senior level Positions A few readers have left private comments asking me what kinds of interview questions I’ve asked potential candidates. Personally, I have a lot more fun with mid-to-senior level positions as… Continue Reading
C# CSV File Writer Here is a C# CSV File Writer class you can use in all your projects. It provides basic functionality for writing data to CSV files and/or Datatables and/or DataRows. Sample usage provided in the class level… Continue Reading
C#: Fastest Way to TRIM strings This will benchmark various techniques to determine in C# .Net: Fastest way to TRIM strings. Removing all the whitespace at the beginning and/or end of a string. Every programmer at some point needs to… Continue Reading
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
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
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
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
C#: Is It Faster to Preallocate Dictionary Sizes? This test will benchmark populating C# Dictionary and ConcurrentDictionary objects to determine in C#: is it faster to preallocate dictionary sizes? Or not? When a Dictionary object is created, its initial capacity… Continue Reading
Fastest Way to Compare Strings in C# .Net What is the fastest way to compare strings in C# .Net? Everyone’s had to do it. A lot of people instinctively use the C# “==” operator. In several programming forums I’ve posted… Continue Reading