Correlated Subqueries in SQL Server
This article explains Correlated subqueries which are a powerful SQL feature for handling row-specific comparisons and complex conditions.
SQL Triggers – An Introduction
SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax…
SQL Script to find all the triggers defined on a database or on a single table
SQL Script to find triggers in SQL Database Sometime we need to find all the triggers defined on the database.…
Interview question – Is Clustered index on column with duplicate values possible?
Through this article, we are going to discuss three important interview questions of SQL which are given below:- 1) Can…
Importance of Best Practices in database programming
Best Practices in database programming For any programming language, just writing the code is not well enough. It should be…
SQL Script to find the missing indexes
Script to find the missing indexes Performance tuning in SQL is important exercise and index creation is an important part…
SQL Script to find the list of all the jobs failed yesterday
One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below…
SQL Script to search stored procedures containing a given text
Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used…
SQL Script to find the tables created from a given date
Below is the SQL query which can be used to find out the tables which are created or modified on…
SQL Script to find the databases size
Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used…