SQL Server -DBA Archives - Page 7 of 17 - NTSEQ:- A IT Infrastructure and Cyber Security Blogs

How to find out the size of Indexes in SQL Server database?

we can find or calculate the size of every indexes in a table through sys.indexes and sys.dm_db_partition_stats DMF. SELECT SCHEMA_NAME(tn.schema_id)

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