SQL Tips

To get the information about how long has your server been running since the last SQL Server startup?   Code: SELECT @@Servername AS ServerName ,…

Problem Statement: Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL Server…

Problem Statement: While managing a large- scale database,  sometimes we might need to replace a string's substring with another. There is always a option of…

Problem Statement : This article explains how to find the starting index of the first occurrence of a pattern in a string or a specified…