, Author at NTSEQ:- A IT Infrastructure and Cyber Security Blogs

Identify Which Connection Is Doing What in SQL Server

Through below script you are able to find out Which Connection Is Doing What in SQL Server at current point

Delete:- Delete is a DML statement and We can use where clause with DELETE to filter & delete specific records.

Through below script you will be able to find the most expensive queries in Sql Server:- SELECT top 20

Through below Query we can find out CPU Pressure in SQL Server If Signal wait shows 15-18 % then it’s

Below script provides you details about TempDB data files and shows how fast TempDB responding to write and read requests

We can find out all the waiting tasks or blocked session in SQL server through below script. SELECT blocking.session_id

This is a very good script to find blocking chain with lead blocker. I got this script from Pinal dave

Through below query you are able to find out blocking on SQL Server. It provides you details information about blocking

Sometimes when you try to restore a database backup in a new database then you will get below error:- we

only one clustered index per table where as you can have more than one non clustered index per table cluster