Technical Article

Live webinar - Prioritizing security: Essential strategies for IT leaders

In today's rapidly evolving landscape, managing the security of large and complex database estates is a critical challenge for organizations. Join us for a webinar on Nov 21 covering “Prioritizing security: Essential strategies for IT leaders,” where Redgate’s security experts will share their tips on how you can safeguard your database estate and minimize reputational risk. There will also be a Q&A session where you can get expert advice from our panelists.

SQLServerCentral Editorial

PASS Summit Time

As the Simple Talk Editor, I have had the privilege of attending numerous conferences these past few years, and all of them have been somewhere between great and amazing. Still, there is something a bit more special about the PASS Summit. Even before I started this position, I have been to the PASS Summit events […]

Blogs

A New Word: Anderance

By

anderance – n. the awareness that your partner perceives the relationship from a totally...

Troubleshooting SQL Server – Starting with the Error Log

By

We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...

From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures

By

In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...

Read the latest Blogs

Forums

Parameter Sensitive Plan Optimization in SQL Server 2022

By Deepam Ghosh

Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...

Minimum Change Tracking Retention

By Steve Jones - SSC Editor

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

AI Steals Joy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AI Steals Joy

Visit the forum

Question of the Day

Minimum Change Tracking Retention

If I am running this code:

ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);
What is the minimum amount of time I can set?

See possible answers