Displays the last statement sent from a client to an instance of Microsoft SQL Server. Arguments  : session_id or request_id Request ID can be retrieved from the below statement :…

When you specify the NOLOCK hint, the query both doesn’t issue shared locks and also doesn’t care about already existing exclusive locks. Thus, you will get the result back very…

USE masterGOALTER DATABASE TempDB MODIFY FILE(NAME = tempdev, FILENAME = ‘f:datatempdb.mdf’)GOALTER DATABASE TempDB MODIFY FILE(NAME = templog, FILENAME = ‘e:datatemplog.ldf’)GONo changes are made to TempDB till SQL Server restarts. Please…

We can query Information_Schema for many purpose :   Select * from Information_Schema.Columns where Column_Name like ‘%%’   Select * from Information_Schema.Tables where Table_Name like ‘%%’

Sample Backup Strategy The following illustration shows the easiest backup strategy under the full recovery model. In the illustration, a full database backup, Db_1, and two routine log backup, Log_1…

1. RAID 0 – This is called as disk striping as data is written across the disks.Read write operations are fast but there is no fault tolerance. 2. RAID 1…

select @@Servername Use this command to get the exact name of the instance.

· Go to RUN –> Type sqlservermanager.msc · Right click on SQL Server(instance name) service and click on properties · Click on Advanced tab · In the start up parameters…

Answer is a straight No,however there are some 3rd party add-ins which you can try and by no way we can say its bug free T-SQL can be used easily…

Release to Manufacturing (RTM) is a milestone where the product will be available for users to download.