Category Archives: SQL Server

This category contains all SQL related articles

Happy New Year 2024

Posted in Festive Greetings, SQL Server | Leave a comment

SQL Joins Tricky Interview Questions

In this article, I have tried to explain the SQL Join concepts with the help of the Interview questions which interview candidate faces regularly. Continue reading

Posted in SQL Server | 32 Comments

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 of After Trigger for Insert Example of After Trigger for Delete Example of After Trigger … Continue reading

Posted in Most Imp SQL Concepts, SQL Advanced, SQL Server, SQL Triggers | Tagged , , , , | 33 Comments

Difference between Stored Procedure and Trigger

Difference between Stored Procedure and Trigger     SQL Stored Procedure & SQL Triggers, both are the important objects of SQL. SQL stored procedure are the set of logically group of SQL statements which are a group to perform a … Continue reading

Posted in Imp SQL Difference, SQL Server, SQL Stored Procedure | Tagged , , , | 15 Comments

Advantages of SQL Stored Procedure

SQL Stored procedure are the set of logically group of SQL statement which are grouped to perform a specific task. Stored procedure are better than the inline SQL queries as they help in securing the database from SQL Injection. It … Continue reading

Posted in SQL Server, SQL Stored Procedure | Tagged , , | 32 Comments

Advantages & Disadvantages of SQL Trigger

Advantages & Disadvantages of SQL Trigger Introduction Triggers are database objects which are needed to perform some predefined action for automatic execution whenever users try to do execute data modification commands (INSERT, DELETE and UPDATE) on the specified tables. Triggers are … Continue reading

Posted in SQL Server, SQL Triggers | Tagged , | Leave a comment

SQL Script: – How to find the database restoring history of SQL Server databases

SQL Script to find database restoring history Sometime we need to find out the history of database restoration to get the answers of following questions: -1) Do we need to restore the database again as there is a possibility that it … Continue reading

Posted in DBA, SQL Database Restoration | Tagged , | 28 Comments

Two Ways to Restore Database from MDF File in SQL Server

Ways to Restore Database from MDF File Introduction In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large level. In such context SQL Server is the best and successful RDBMS … Continue reading

Posted in DBA, SQL Database Restoration, SQL Tips | 31 Comments

How to Resume Suspended Database Mirroring in SQL Server ?

Resuming Suspended Database Mirroring in SQL Overview Database mirroring is a feature in SQL Server which is creating and maintaining the redundant copies of the database. The purpose behind database mirroring is continuous data availability and minimizes the loss of … Continue reading

Posted in DBA, SQL Database Mirroring | 27 Comments

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 can use the below SQL Query:-SELECT tbl.name as [Table Name] , trig.name as [Trigger Name] … Continue reading

Posted in SQL Advanced, SQL Tips, SQL Triggers | Tagged , | 30 Comments