Awesome SQL Server Feature
The second Tuesday of April 2016 is now upon us and you know what that means. Well, I hope you know...
2016-04-13
773 reads
The second Tuesday of April 2016 is now upon us and you know what that means. Well, I hope you know...
2016-04-13
773 reads
There are a lot of cool features in SQL Server that ROCK! It is really hard to pick just one with so many cool features that can make life...
2016-04-13
3 reads
Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to...
2016-04-02
718 reads
Of all the fundamental concepts within SQL Server, nothing is potentially more basic and fundamental than the often overlooked Select statement.
Related Posts:
Changing Default Logs Directory - Back to Basics...
2016-04-02
3 reads
Many moons ago, I posted a script to help report on the human friendly scheduling information for SSRS subscriptions. You...
2016-04-12 (first published: 2016-03-29)
2,589 reads
SQL Agent job schedules should be easy to read for humans if for nothing else than the fact that you have to provide this information to the auditors from...
2016-03-29
3 reads
Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your...
2016-03-16
532 reads
Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your purview. Then a small problem occurs: Index Cannot Be...
2016-03-16
19 reads
Long Time Coming
With less than a week before the Richmond SQLSaturday event, I am finally getting this post done – maybe.
This...
2016-03-11
512 reads
Three days of presentations in Richmond Virginia. From Naked SQL to Wheel of Doom - there is a wide breadth of knowledge to be shared.
Related Posts:
An Experiment with Deadlocks...
2016-03-11
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item Minimum Change Tracking Retention
Comments posted to this topic are about the item AI Steals Joy
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