SQL

I was unable to uninstall SQL Server after it was removed from Failover Cluster Manager. It was logging below error in application log: P...

dbo.sp_MSforeachdb procedure will execute the attached string as a command against every database on the server. Any question mark(?) , wi...

You can use the below query to get all tables with No of rows and size. User required View Database State permission on the Server to use b...

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