SQL Toast

Very rarely there is a need to force an execution plan and even more rarely we should be doing it....

2018-07-30 (first published: 2018-07-20)

12,984 reads

Send SMS from SQL Server

We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production...

2014-03-31

1,916 reads

There is a way by which we can merge the .trc and .blg files to get a great view as...

2013-10-17 (first published: 2013-10-09)

6,290 reads

INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....

2013-09-29

3,879 reads

I think we might have forgotten this a bit, but on one of the...

I refresh my test SQL Servers at least monthly with a fresh VM. Setting...

Embracing Total Responsibility In every organization there comes a moment when teams must choose...

Monkey type Typing Club is a unique typing practice website that offers several features...

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. ...

I run this command on my SQL Server 2022 database:

ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;

What is the default data retention period?