Tag Archives: SQL Advance Concepts

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

Replication in SQL Server

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. … Continue reading

Posted in SQL Replication, SQL Server | Tagged , | 19 Comments

Log Shipping in SQL Server

Log Shipping in SQL Server Log Shipping Log Shipping in SQL Server is a process of keeping the latest copy of the database of the primary database server on the secondary database server with the help of transaction logs backup. … Continue reading

Posted in SQL Log Shipping, SQL Server | Tagged , | Leave a comment

Rebuild And Reorganization of Indexes

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 … Continue reading

Posted in SQL Indexes, SQL Server | Tagged , | 31 Comments

Fragmentation in SQL Server

Fragmentation:- Fragmentation can be defined as condition where data is stored in a non continuous manner. This article help in understanding the fragmentation in SQL Server. It can be defined into two types1. Internal Fragmentation 2. External Fragmentation Internal Fragmentation:- … Continue reading

Posted in SQL Indexes, SQL Server | Tagged , | 2 Comments

Isolation levels in SQL Server

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 … Continue reading

Posted in SQL Isolation Level, SQL Server | Tagged , , | 33 Comments

Merge Command In Sql Server

Merge Command:- Merge command is a new feature introduced in the SQL Server 2008. It can perform Update, Insert and delete operations at a single statement which means all the data is processed and read only once instead of three … Continue reading

Posted in SQL Merge Command, SQL Server | Tagged , | 4 Comments

Derived Table In Sql Server

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 … Continue reading

Posted in SQL Derived Table, SQL Server | Tagged , | 31 Comments

Pivot and Unpivot table in SQL SERVER

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 … Continue reading

Posted in Most Imp SQL Concepts, SQL Pivot and Unpivot table, SQL Server | Tagged , | 25 Comments

SQL Server- Output clause

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 … Continue reading

Posted in SQL Output Clause, SQL Server | Tagged , | 28 Comments