Choosing the right professional
I’m writing this blog post from my bed, you may think that’s a little too much information there is a...
2012-01-11
479 reads
Richard Douglas
2011 – The dissection
Blimey, doesn’t seem like a year since I wrote my last end of year review End of year review 2010...
2012-01-01
675 reads
Why I blog #Meme15
I’d seen various #meme tweets on twitter but it wasn’t until I saw this blog by John Sansom (Blog|Twitter) that...
2011-12-15
471 reads
T-SQL Tuesday #025 – How to view the size of all your databases – #TSQL2sDay
It’s that time of the month again, no not time, T-SQL time! If you have not heard of T-SQL Tuesday...
2011-12-13
862 reads
Speaking Engagements
It only seems like a couple of weeks ago since I wrote a post about new years resolutions which you...
2011-11-15
519 reads
Writing queries without data
Sometimes it’s not possible to have the data you need in order to create the most efficient queries possible. This...
2011-11-15
694 reads
Top 5 Third Party Quotes
Unless you’ve worked in a vacuum the likelyhood is that you either are a third company or you have many...
2011-11-09
487 reads
SQLRelay: The Final Sprint
The UK SQL community has never had so many events in such a short space of time. Last week there...
2011-10-06
418 reads
SQLRelay: The Third Leg
Feedback from the second leg of SQLRelay was very positive indeed. The attendees from my Maidenhead group were very impressed...
2011-10-05
672 reads
Blogs
Leading Through Change: Guiding Teams in Times of Uncertainty
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
Forums
Compatibility levels on database changing them and impacts.
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
Question of the Day
Changing the Recovery Time
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers