USE master GO SET NOCOUNT ON DECLARE @BackupPath nvarchar(500) DECLARE @BackupDBFile nvarchar(500) DECLARE @BackupLogFile...

 Following query shows all records those are available in table 1 but not available in table 2 SELECT * FROM [TABLE1] LEFT JOIN [TABLE2]...

1. Determine the logical file names of the tempdb database and their current location on the disk. SELECT name, physical_name FROM...

sys.dm_tran_current_transaction function

Please visit following URL

DECLARE @oldowner sysname, @newowner sysname, @sql varchar(1000) SELECT   @oldowner = 'OLD_OWNER',   @newowner =...

Standard Security Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;   Trusted...

HTTP protocol

Online Index is a feature available after SQL Server 2005, prevously DBAs had to build index during off-peak hours as SQL Server locks data for...

TempDB will be re-created automatically when you restart SQLServer. You can't delete TempDB while SQLServer is running.