Data Dictionary refers to a comprehensive repository that documents and describes the data elements used within the organisation ecosystem. It provides detailed information about data…
Mihir Shah23/11/2023
In today's data-driven world, businesses across all industries heavily rely on data to make informed decisions and gain a competitive edge. However, the quality and…
admin31/07/2023
To get the information about how long has your server been running since the last SQL Server startup? SELECT @@Servername AS ServerName , create_date…
Yash Shah31/07/2023
Introduction: In today's data-driven world, organizations increasingly rely on data analytics to make informed decisions. Power BI, a leading business intelligence tool from Microsoft, enables…
admin31/07/2023
To get the information about how long has your server been running since the last SQL Server startup? Code: SELECT @@Servername AS ServerName ,…
Yash Shah09/02/2023
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…
admin09/12/2022
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…
admin08/12/2022
Problem Statement : This article explains how to find the starting index of the first occurrence of a pattern in a string or a specified…
admin08/12/2022
Problem Statement: Long running queries have been found in the plan cache. These may be ETL, reports, or other queries that should run long. Or…
Yash Shah07/12/2022