SQL Server Archives - Technology with Vivek Johari

SQL Joins Tricky Interview Questions

April 17, 2019November 12, 2020 vivekjohari29 Comments

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

SQL Triggers – An Introduction

December 8, 2018January 31, 2019 vivekjohari33 Comments

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 for Update Instead of Triggers DDL Triggers DDL Trigger for Create Table DDL Trigger for […]

Difference between Stored Procedure and Trigger

November 1, 2018 vivekjohari15 Comments

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 specific task. Trigger are also similar to SQL Stored procedure as they can also be a […]

Advantages of SQL Stored Procedure

November 1, 2018 vivekjohari32 Comments

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 also help in increasing the performance of the Database. There are many other Advantages of SQL […]

Advantages & Disadvantages of SQL Trigger

November 1, 2018November 1, 2018 vivekjohariLeave a Comment

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 helpful since it can help in maintaining the integrity of the data in database tables […]

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

March 30, 2018April 27, 2018 vivekjohari28 Comments

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 is restored recently? 2) Which backup file (with location information) is used for database restoration? […]

Two Ways to Restore Database from MDF File in SQL Server

July 27, 2017April 27, 2018 Andrew Jackson31 Comments

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 which provides highly integrated services to manipulate the SQL database over the Server. As we […]

How to Resume Suspended Database Mirroring in SQL Server ?

September 3, 2016April 27, 2018 Andrew Jackson27 Comments

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 the data. Redundancy ensures that there is always a one backup copy of the database […]

SQL Script to find all the triggers defined on a database or on a single table

August 14, 2015April 27, 2018 vivekjohari30 Comments

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] , trig.is_disabled FROM [sys].[triggers] as trig INNER JOIN sys.tables as tbl ON trig.parent_id = tbl.object_idIn […]

Interview question – Is Clustered index on column with duplicate values possible?

August 13, 2015January 31, 2019 vivekjohariLeave a Comment

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 a column containing duplicate values? 2) Can we create a Primary Key on a table on which a clustered index is already defined? 3) If a clustered index is already defined on a […]