Posts

Showing posts from October, 2021

Generating unique string in C#

One of the solution in C# that generates unique string.  class UniqueString { private static readonly Random random = new Random(); private static readonly object syncLock = new object(); // Map to store 62 possible characters   private static readonly char[] charMap = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789".ToCharArray(); /// <summary> /// Generates unique string /// </summary> /// <param name="strLen">Length of the string.</param> /// <returns>Unique string of specified length.</returns> public static string GenerateUniqueString(int strLen) { if (strLen <= 0) { return null; } StringBuilder sb = new StringBuilder(); for (int i = 0; i < strLen; i++) { lock (syncLock) // synchronize { _ = sb.Append(charMap[random.Next(62)]); } } return sb.ToString(); } public static void Main() { // generate 10 character string Console...

SQL Query Optimization

SQL query optimization is bare minimum  requirement when working with queries. Need to look for Indexes, Execution plan etc. Few links that help to understand query optimization. SQL Query Optimization    query-processing-architecture-guide optimize-query-performance-sql-server