Happy New Year Friends
Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and Happiness.
2016-01-01
Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and Happiness.
2016-01-01
SQL Server is a database management system which enables to store and retrieve data from the database. Due to some...
2015-12-31
1,393 reads
SQL Server is a database management system which enables to store and retrieve data from the database. Due to some reasons like virus infection, improper closing of the Server,...
2015-12-31
8 reads
Wishingyoua very
HappyIndependenceDay
" We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific...
2015-08-15
733 reads
Wishing you a very
Happy Independence Day
" We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made....
2015-08-15
Sometime we need to find all the triggers defined on the database. So in this case, we can use the...
2015-08-14
1,668 reads
Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-SELECT tbl.name as [Table Name] ...
2015-08-14
5 reads
Through this article, we are going to discuss three important interview questions of SQL which are given below:-
1) Can we...
2015-08-13
6,968 reads
Through this article, we are going to discuss three important interview questions of SQL which are given below:-
1) Can we create clustered index on a column containing duplicate values?
2) Can we create...
2015-08-13
5 reads
Suppose we have a table emp_plan which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate)....
2015-08-03
664 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...
A blockchain development company helps businesses leverage decentralized technology to improve transparency, security, and...
We have created a parent table, child table & Audit log table in SQL...
Comments posted to this topic are about the item Change Tracking Default Retention
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