December 2012 - Technology with Vivek Johari

Replication in SQL Server

December 31, 2012February 1, 2019 vivekjohari19 Comments

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 […]

Log Shipping in SQL Server

December 31, 2012October 28, 2018 vivekjohariLeave a Comment

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. It is done on a regular basis to minimize the loss of the database in […]

Rebuild And Reorganization of Indexes

December 31, 2012October 7, 2018 vivekjohari31 Comments

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 […]

Fragmentation in SQL Server

December 31, 2012April 27, 2018 vivekjohari2 Comments

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 […]