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.





Popular posts from this blog

Internet Information Services (IIS) on Load Balancer and shared folder for files

Image
In the load balancer setup for windows Internet Information Services (IIS) if shared folder is used for files to upload and download create virtual directory under application folder with alias as Upload(whatever you prefer) and physical path as \\sharedfilefolder\files$\AppFiles\ where files is the shared folder on sharedfilefolder and AppFiles is subfolder in the files folder Have the same setup on each server and the application works fine with upload and download of files from load balancer URL.
Read more

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...
Read more