Log Shipping  By Abi  Chapagai (Revised) In SQL Server, transaction log provides an ability to recover a database to a point in time. Log shipping is a process of copying the transaction log back up from a source server to a destination server and restore on the destination server.  The main objective of implementing log shipping is to maintain two SQL Server...

Introduction  Replication is the process of copying data between two databases on the same server or different servers on the same database. This is one of the methods to maintain the redundant database site for disaster recovery purpose.  Replication methodology maintains copies of main database from the primary server on the secondary sever, both of the databases...

With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority of cases). The SQL optimiser struggles when dealing with cursor ridden statements, when a FETCH command is executed, its moreorless the same as an extra SELECT command being executed. Sometimes cursors are necessary, especially when executing...

My first guest editorial published ! http://www.sqlservercentral.com/articles/Editorial/70725/ Would appreciate any comments you have.

This is something we had to do again recently and its improved our performance and query speeds on one particular system. This information is readily available from various sources and blogs, I just wanted to re-blog and ensure we’re all aware of the benefits gained from using AWE ! Enabling Memory Support for over 4GB of Physical Memory To enable Address...