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
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#: 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