Subscribe to this blog
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…
8 comments, 356 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…
0 comments, 309 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…
0 comments, 306 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…
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…
3 comments, 273 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.
0 comments, 304 reads
Posted in Vivek's SQL Notes on 31 December 2012