SQL

Use below queries to get the session details SELECT S.Session_ID AS [Session ID], S.Status, S.Host_Name AS [Host], C.Client_Net_Address A...

Use below query to move TempDB data and log files to some other location/drive: ALTER DATABASE Database_Name MODIFY FILE ( NAME = Logical...

If you want to stop all database successful backups message in error log than use below DBCC command. This will not record successful backu...

Below queries returns aggregate performance statistics for cached query plans.  The result contains one row per query within the cached pl...

2 – The system cannot find the file specified. 5 – Access denied. 52 – You were not connected because a duplicate name exists on the net...