SQLServerCentral Runs sp_Blitz - Performance Part 2
The second part of our performance examination on the SQLServerCentral database servers using the sp_Blitz script from Brent Ozar, PLF.
2013-03-21
6,938 reads
The second part of our performance examination on the SQLServerCentral database servers using the sp_Blitz script from Brent Ozar, PLF.
2013-03-21
6,938 reads
The growth of data, and the sheer scale of data we store and manage is stunning. Steve Jones looks at the rates of growth these days.
2013-03-21
156 reads
On this quiet Friday, Steve Jones skips a poll and talks about life. This editorial was originally published on Jun 6, 2008. It is being republished as Steve is on vacation.
2013-03-20 (first published: 2008-06-06)
249 reads
Steve Jones talks about the serious storage that EMC is bringing to the Vatican library.
2013-03-19
200 reads
2013-03-19
1,758 reads
This week Steve Jones talks encryption and why you shouldn't be implementing anything you've invented.
2013-03-18
186 reads
Today Steve Jones talks about backups. Setting up a process is good, but you cannot count on it working forever. You need to check periodically to be sure it's working, and that your skills are not deteriorating.
2013-03-18
196 reads
This Friday Steve Jones notes that changing and altering your opinions is good and invites you to share things you might have learned that changed your mind in the past.
2013-03-15
129 reads
Whether practicing for an exam or interview, or just wanting to see who's got the biggest SQL Server brain in your office, this book is perfect. Containing 100 SQL Server Central Questions of the Day, this book is a great way to test yourself and increase your knowledge.
2013-03-15
3,522 reads
It’s the second Tuesday of the month and time for T-SQL Tuesday again. This is a monthly blog party, where...
2013-03-15 (first published: 2013-03-12)
2,844 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