Find Queries Using Highest CPU Utilization in SQL Server
1.7kviews 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...
SQLServerLog.com - Database Tips, Techniques and Tutorials
Find Jobs Name and Owners in SQL Server
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...
Find All Enabled and Running Jobs in SQL Server
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...
Understanding and Troubleshooting SQL Server Performance Issues
1.2kviews 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...
Different Types of SQL Server Locks
771views Sometimes conflicts occurs in SQL Server due to concurrent transactions which can be resolved by using lock modes. Locking is a very common problem and its a logical issue which means you cannot...
SQL IDENTITY Column – Auto Increment Column Values
SQL IDENTITY column generates a unique number when a new record is inserted in a table and it is normally used with CREATE TABLE or ALTER TABLE statement. Syntax Following create table statement generates unique...
