SQL Server replication - August 29, 2008 at 18:00 PM by Amit Satpute
What are the advantages and disadvantages of merge replication?
It provides built-in and custom conflict resolution capabilities.
It allows for the synchronization of data from multiple tables at one time.
It provides rich data replication options like selection of article types and
filtering and identity range management.
Merge replication requires more configuration and maintenance at the server
SQL Server replication - May 19, 2009 at 18:00 AM by Rajmeet Ghai
What is Replication and Database Mirroring?
Database Mirroring allows two copies of a database on different computers.
Clients can get access to only one database called as”principal” database. Any
changes applied to principal database, are applied on the copy also called as
the mirror. This is achieved by applying the transaction log for every insert,
update, or deletion made on the primary database. This increases the
availability of a database incase of a failure.
Answer - Master database is system database.
It contains information about server’s configuration. It is a very important
database and important to backup Master.....
Answer - SQL Profiler is a tool that stores
events from the server. SQL Profiler saves the events in the trace file......
Answer - A transaction is a set of
operations that works as a single unit. The ransactions can be categorized into
explicit, autocommit, and implicit....
Answer - Restricting query result means
return of required rows instead of all rows of the table. This helps in
reducing network traffic......
Answer - Both are used for filtering of
records based on filtered criteria.....
Answer - This is the default and recommended
security mode. In this mode, access to SQL server is controlled by Windows