Tom Staab

Get Set For Speed

Loops are common in application code, but set-based solutions are the way to go with SQL.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.82 (22)

You rated this post out of 5. Change rating

2018-02-23 (first published: 2015-12-29)

6,361 reads

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

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

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

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

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

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

If I am running this code:

ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);

What are the possible choices for xxx?