Category: Database Administration
If your database contains hundreds or thousands of tables then it’s difficult to find which tables are missing clustered index in a database manually. You can go through this article which provides very simple...
We have a query which is very useful for DBAs and database users to find total number of connections used by particular login on database instance for all databases or on particular database. Here I am...
As a DBA, time to time we have to trace SQL queries which are consuming highest CPU utilization in SQL Server and need to tune those queries. You can refer below query which provides...
If you want to find SQL Jobs Name and owners by which particular job is running then you can find the same by joining sysjobs and syslogins from msdb and master database respectively as given below....
As a DBA sometimes we need to verify certain details for currently running jobs, jobs steps, jobs description and commands and queries used in jobs etc. We can extract these details by joining tables...
SQL Server Performance Tuning is a major topic for Database Administrators and it is also a challenge for them to trace the issues and tune it. We should know what are the major areas...