Tag Archives: SQL Advance Concepts

SQL Triggers – An Introduction

By | December 8, 2018

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… Read More »

Replication in SQL Server

By | December 31, 2012

Replication in SQL Server Introduction Replication in SQL Server is a way of distribution of database and their objects from one master database to one or more recipient databases which can be on the same server or on the remote server. It is a set of technologies for copying and distributing data and database objects from one… Read More »

Rebuild And Reorganization of Indexes

By | December 31, 2012

Rebuild and  Reorganization of Indexes SQL Server has the ability of maintaining the indexes whenever we makes changes (update, Insert, Delete) in the tables. Over a period of time, the may causes the fragmentation on the table in which  the logical ordering based on the key value pairs does not match with the physical ordering inside the data… Read More »

Fragmentation in SQL Server

By | December 31, 2012

Fragmentation:- Fragmentation can be defined as condition where data is stored in a non continuous manner. In can be defined into two types 1. Internal Fragmentation 2. External Fragmentation Internal Fragmentation:- In this fragmentation, there exists a space between the different records within a page. This is caused due to the Insert, delete or Update process… Read More »

Isolation levels in SQL Server

By | August 19, 2012

Isolation levels :- Isolation level is required to isolate a resource and protect it from other transactions. This is achieved with the help of locks but what locks are needed and how they can be established is decided on the isolation level set on the database level. If low level of Isolation is set, it… Read More »

Derived Table In Sql Server

By | April 15, 2012

Derived tables:-  Derived tables are the tables which are created on the fly with the help of the Select statement. It is different from the temporary table in the way that  in case of temporary table, first we have to create a temporary table,  insert the data into the table, select the data from the temporary table and… Read More »

Pivot and Unpivot table in SQL SERVER

By | April 14, 2012

Pivot Table:- Pivot tables are used to summarize and display the data, specially in case of report data by means of aggregating the values. Pivot table can be used if we want to display the unique values of the column of a table as the columns of another table. It turns the unique values of a specified… Read More »

SQL Server- Output clause

By | January 22, 2012

Output Clause:- The SQL SERVER 2005 gives us an Output Clause which gives us the information about each row affected by the Insert, Update , Delete and Merge statement. It is more useful than @@scope_Identity and @@Identity column since these global variables gives us the information about the last inserted identity column value, but the Output clause gives us… Read More »