Find Queries Using Highest CPU Utilization in SQL Server
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...
SQLServerLog.com - Database Tips, Techniques and Tutorials
Find Jobs Name and Owners in SQL Server
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....
Find All Enabled and Running Jobs in SQL Server
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...
Understanding and Troubleshooting SQL Server Performance Issues
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...
Different Types of SQL Server Locks
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 solve...
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...
