2013-04-12
1,829 reads
2013-04-12
1,829 reads
All software has default values, some of which might not suit your environment. This is especially true with regards to security settings.
2013-04-11
91 reads
There can be more to managing a SQL Server instance than just examining the performance metrics. There are times when understanding how your system is performing for the application is important.
2013-04-11
1,435 reads
What's important in an IT employee? Steve Jones talks about the skills and measurements CIOs want today and tomorrow. Today's editorial was originally released on July 22, 2008. It is being re-published as Steve is at SQL Intersection.
2013-04-10 (first published: 2008-07-22)
582 reads
Does your IT organization bring value to your company? Steve Jones takes a look at some of the ways you can do this. This editorial was originally published on July 2, 2008. It is being re-published as Steve is at SQL Intersection.
2013-04-09 (first published: 2008-07-02)
152 reads
I had known that the Resource Governor is always running in modern versions of SQL Server. It’s core to the...
2013-04-08
1,093 reads
Sometimes auditing for one certification might help you pass another, but don't count on it.
2013-04-08
134 reads
A new memory technology has the potential to dramatically speed up access for computer systems.
2013-04-08
154 reads
This is a busy travel week for me, and one of those times that stresses out everyone in the household....
2013-04-08
711 reads
It’s time for a new laptop. I don’t think it’s time, as I love the Macbook Air I bought a...
2013-04-05 (first published: 2013-03-28)
3,910 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