There are so many options for running SQL Server now. It can feel a little intimidating. You’ve spent years gaining experience with SQL running on Windows Server. On bare...
2019-09-03 (first published: 2019-08-22)
556 reads
SQL Server Integration Services is well designed for retrieving and processing data on the fly, directly in the data flow pipeline. However, there are circumstances that occasionally require the...
2019-09-03
28 reads
So, if you’ve been following my blog you know my love for internals. Well, I needed to find out exactly how something worked at the startup of a SQL...
2019-09-03
3 reads
Watch this week's video on YouTube
Last week's post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace.
In addition...
2019-09-03
1 reads
Watch this week's video on YouTube
Last week's post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace.
In addition...
2019-09-03
13 reads
Yeah, Redgate is only one year younger than my children. What’s really frightening is that I’ve been using Redgate’s products since my kids were a year old. I was...
2019-09-02
27 reads
There is no excerpt because this is a protected post.
2019-09-02
12 reads
There is no excerpt because this is a protected post.
2019-09-02
5 reads
Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by...
2019-09-02 (first published: 2019-08-22)
293 reads
Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way....
2019-09-02
12 reads
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