Category: Articles
-
Schema changes in SQL Server 2005 Transactional Replication
Schema changes will be replicated by default. I am adding a column named street to the table Address using the below command,
-
How to Configure Peer to Peer replication – GUI
This article takes you with simple steps in configuring peer-to-peer replication. P2P replication is new to SQL server 2005 and though looks like complex in theory its one of the easiest to configure and maintain on long run. The following steps take you through the configuration process.
-
Backup compression in SQL Server 2008
Introduction Backup compression is one of the feature expected by every administrator to minimize the backup size and to squeeze the time taken for backup. In previous versions of SQL Server most of us are going for 3rd party tools like Quests Litespeed, Redgates SQL Backup etc. for which we need to pay additional amount.…
-
Difference between TRUNCATE and DELETE command
Lets see the difference between DELETE and TRUNCATE command as below
-
How to use Copy Database Wizard
What is copy database wizard? Copy Database Wizard is a new feature from SQL Server 2005 onwards. You can make use of this feature to copy move databases between different instances of SQL Server. It can be used for the below purposes Transfer a database when the database is still available to users by using…