SQL Triggers – An Introduction
SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax of the After trigger Example...
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. So in this case, we...
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 we create clustered index on...
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 written using the best practices....
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 of it. Sometimes base on the frequent...
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 can be used...
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 to find out the list...
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 or from a given date....
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 to find out the size...
T-SQL script to find the growth size of database files
Below query can be used to see the growth size of database files. DECLARE @filename NVARCHAR(1000); DECLARE @bc INT; DECLARE @ec INT; DECLARE @bfn VARCHAR(1000);...