Compañero Conference and SQL Modernization Roadshow
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to...
2017-09-27
542 reads
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to...
2017-09-27
542 reads
I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered...
2017-09-20
427 reads
Joe Obbish wrote an epic post a few weeks ago about loading a trillion rows into a non-partitioned table in...
2017-09-13
440 reads
I got a strange request in a Slack channel the other day. A colleague in South Africa, who uses Windows,...
2017-09-06
385 reads
Last week, I posted this statement on Twitter, along with a screen capture of the official Microsoft documentation: Reminder: Max...
2017-08-30
340 reads
This coming weekend, at SQLSaturday #635 in Vancouver BC, I will be presenting a brand new talk about Temporal Tables,...
2017-08-23
119 reads
For the longest time, MySQL has been the recommended database platform for blogs and other websites. It’s free. It’s available...
2017-08-16
149 reads
I was fresh off the boat* from South Africa, working in a small computer store in an equally small town...
2017-08-09
146 reads
Last week we looked at ACID compliance. This week we dive a little deeper into the Isolation portion, and what...
2017-08-02
128 reads
Relational database management systems (RDBMS) such as SQL Server, Oracle, MySQL, and PostgreSQL use transactions to allow concurrent users to...
2017-07-26
142 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...
We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We...
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