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...
2012-12-31
2,121 reads
Replication is a way of distribution of database and their objects from one master database to one or more recipient databases...
2012-12-31
2,121 reads
Log Shipping:- Log Shipping is a process of keeping the latest copy of the database of the primary database server...
2012-12-31
1,518 reads
Rebuild and Reorganization of Indexes:- SQL Server has the ability of maintaining the indexes whenever we makes changes (update, Insert,...
2012-12-31
2,729 reads
Fragmentation:- Fragmentation can be defined as condition where data is stored in a non continuous manner. In can be defined into...
2012-12-31
1,441 reads
HappyNewYear2013
May this new year bring lots of Happiness in all of your life. Let welcome 2013 together with lots of...
2012-12-31
1,292 reads
Wish you all a very happy and blessed festive season. May this festival of lights brings more brightness in your...
2012-11-13
690 reads
Boyce - Codd Normal Form (BCNF) :- A normal form is said to be a Boyce - Codd Normal Form if it is in...
2012-08-19
4,214 reads
Isolation levels :- Isolation level is required to isolate a resource and protect it from other transactions. This is achieved with...
2012-08-19
22,094 reads
Merge Command:- Merge command is a new feature introduced in the SQL Server 2008. It can perform Update, Insert and...
2012-04-17
1,735 reads
Many times we need to alter the table definition by adding , deleting or updating a column in the table. In...
2012-04-15
1,415 reads
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
Comments posted to this topic are about the item Change Tracking Default Retention
I am trying to create a subscription that posts to a one drive directory. ...
Comments posted to this topic are about the item What is Delayed Durability in...
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers