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

How to find or capture out currently executing long time running queries in SQL Server ?

This is one of the best script to troubleshoot SQL Server performance tuning. Below Script gives you all current running

— Find Logins having more than one session SELECT login_name , COUNT(session_id) AS session_count FROM sys.dm_exec_sessions WHERE is_user_process = 1

Through Below Script we are able to find who is connected to SSMS:- SELECT dec.client_net_address , des.host_name , dest.text FROM

Below query identifies sources of multiple connections to your SQL Server instance and also allow DBA to identify where the

We can get table details with two ways: Through below script we are able to get all table details in

you can find out beneficial missing index in a database through below Script. It is very important to know that

Through Below Script we can remove index fragmentation of a database in Sql Server.This is a very useful script to

Characteristics of constructors are below:- These are called automatically when the objects are created. All objects of the class having