Presenting with SSMS (Day 29)
If you are presenting with SSMS, then there are some extra steps that you need to take. These steps are...
2018-01-29
832 reads
If you are presenting with SSMS, then there are some extra steps that you need to take. These steps are...
2018-01-29
832 reads
Over the last several weeks, we have been making several changes to various settings in SSMS. Now that you have...
2018-01-28
387 reads
When you are performance tuning code, you will frequently examine the execution plans to see what is happening. As you...
2018-01-27
446 reads
Wayne’s Tips and Tricks for SSMS
SQL Server Management Studio (SSMS ) is a program that many just launch daily (or only...
2018-01-26
690 reads
We all know that we should liberally document our code with comments, so that others (and even yourself) will know...
2018-01-26
375 reads
Let's explore how SQL Server 2017 automatically adapts between nested loop and hash join operators
2018-01-25
1,213 reads
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
333 reads
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
306 reads
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
351 reads
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
1,188 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