SQL RNNR

Blog Post

S3OLV March 2011

The Ides of March are upon us and that means that we have another opportunity to learn some stuff about SQL Server.  We have that opportunity because it is...

2011-03-02

3 reads

Blog Post

Delimiting Results

Recently, I came across the need to delimit some data in order to be able to test some procedures that I was writing.  The procedures need to be able...

2011-03-01

Blogs

T-SQL Tuesday #190–Mastering a New Technical Skill

By

It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...

Getting Started with the MSSQL AI Agent in VS Code

By

Recently I was working in VS Code and I saw a walkthrough for the...

Summer Speaking Summary 2025

By

In the blink of an eye, summer has passed. I don’t know about you,...

Read the latest Blogs

Forums

Azure elastic query credential question

By cphite

I am trying to check out elastic query between two test instances we have...

Change Tracking Data Retention Options

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Change Tracking Data Retention Options

Requiring Technical Debt Payments

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Requiring Technical Debt Payments

Visit the forum

Question of the Day

Change Tracking Data Retention Options

If I am running this code:

ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);
What are the possible choices for xxx?

See possible answers