Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Vivek's SQL Notes

Vivek johari is currently a Analyst and have more that 5.5 yeras of experience in database. He has Master degree in Computer and also he is Microsoft certified Sql DBA (MCTS)& Microsoft certified SQl BI professional(MCTS). He is also Oracle certified profession(OCP)DBA in ORACLE 10g and ORACLE 9i.He has the experience of working in PL/SQL, T-SQL and SSIS/SSRS. His work basically involved designing and optimization of the Database.He has also published many database articles on his blog Technologies with Vivek Johari.

Archives: December 2012

Replication in SQL Server


Replication  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

9 comments, 814 reads

Posted in Vivek's SQL Notes on 31 December 2012

Log Shipping in SQL Server

Log Shipping:- Log Shipping 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 case of database fail…

Read more

1 comments, 557 reads

Posted in Vivek's SQL Notes on 31 December 2012

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 logical ordering based on the key value pairs does not match with…

Read more

0 comments, 854 reads

Posted in Vivek's SQL Notes on 31 December 2012

Fragmentation in SQL Server

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…

Read more

3 comments, 511 reads

Posted in Vivek's SQL Notes on 31 December 2012

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.



Read more

0 comments, 450 reads

Posted in Vivek's SQL Notes on 31 December 2012