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!
1

SQL: Rebuild Indexes, Update Statistics, and Shrink Databases on SQL Server

Posted on September 12, 2016 by David Lozinski
SQL Code

SQL to Rebuild Indexes, Update Statistics, and Shrink Databases Here is SQL to Rebuild Indexes, Update Statistics, and Shrink Databases on SQL Server. This code works on SQL Server 2008 – 2016. It should help keeping your databases running at… Continue Reading →

Code, SQL Code Indexes, Shrink Database, sql, statistics
1

C#: Azure Blob Storage Manager Class

Posted on July 3, 2016 by David Lozinski
C# Code

C# Azure Blob Storage Manager Class Here is a C# Azure Blob Storage Manager Class which I hope you find useful as I’ve needed it often enough. It provides basic functionality for blob storage in the Azure cloud. Sample usage… Continue Reading →

C# Code, Code .Net, Azure, blob storage, C#, class, CloudBlobClient, CloudBlobContainer, CloudBlockBlob, CloudStorageAccount
4

C#: For Vs ForEach Vs While

Posted on May 13, 2016 by David Lozinski
C#

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 →

C# .Net, C#, For, ForEach, Parallel.For, Parallel.ForEach, While
3

Tricky C# and SQL Interview Questions

Posted on April 10, 2016 by David Lozinski

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 →

General .Net, C#, Interview Questions, sql, Tricky Questions
0

C#: CSV File Writer Class

Posted on March 25, 2016 by David Lozinski
C# Code

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# Code, Code .Net, C#, class, csv file
2

C#: Fastest way to TRIM strings

Posted on January 9, 2016 by David Lozinski
C#

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 →

C# .Net, C#, IsWhiteSpace, Remove, string, substring, trim, TrimEnd, TrimStart
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

Post navigation

Older Articles
Newer Articles

Subscribe to be notified of new posts:

Loading

Most Popular Last 30 Days

  • SQL: Fastest way to insert new records where one… (637)
  • C# .Net: Fastest Way to Read Text Files (610)
  • SQL: LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX (348)
  • C# .Net: Fastest Way to check if a string occurs… (310)
  • SQL: Fastest way to compare multiple column values (302)

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