Database Administration / Performance Tuning / SQL Server
by Manzoor Siddiqui · Published October 8, 2015 · Last modified November 12, 2015
1.1kviews 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...
Database Administration / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published October 7, 2015 · Last modified October 29, 2015
901views 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...
Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published October 6, 2015 · Last modified October 25, 2015
1.8kviews 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...
Database Administration / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published October 5, 2015 · Last modified October 24, 2015
1.1kviews 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...
Database Administration / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published October 4, 2015 · Last modified October 23, 2015
1.1kviews 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...
Database Administration / Performance Tuning / SQL Server
by Manzoor Siddiqui · Published October 3, 2015 · Last modified October 15, 2015
1.3kviews 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...
