SQL

In SQL Server there is not direct function to calculate the number of words in a string.  But we can calculate the number of words in foll...

Use below query to find the Index with size in a table: SELECT OBJECT_Name(I.OBJECT_ID) AS TableName, I.index_ID AS IndexID, I.Name...

Today I had to change the domain account on some Server. After I had changed the account the SQL server was not starting and showing below...

Use below script to find the No of Reads / Writes on Database files SELECT DB_Name(MF.Database_ID) AS [DB Name],        MF.Physical_Name...

Use below script to track database growth over a period of time: WITH C AS ( SELECT  RN = ROW_NUMBER() OVER( ORDER BY Backup_Start_Date...