Monthly Archives: December 2012

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

Welcome 2013

Happy New Year 2013 May this new year bring lots of Happiness in all of your life. Let  welcome 2013 together with lots of Hopes and happiness.

Posted in Miscellaneous | Tagged | Leave a comment