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...
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 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...
SQL FOREIGN KEY constraint represents relationship between tables. A Foreign Key is a column(s) whose values are derived from the PRIMARY KEY or UNIQUE KEY of some other table. If you want to associate records of...
SQL PRIMARY KEY constraint uniquely identifies each row in a database table. A primary key column cannot have NULL values. A table can have only one primary key with single or multiple fields. Primary...
More
