Getting Excited: SQLBits is Coming!
Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling...
2011-09-19
864 reads
Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling...
2011-09-19
864 reads
Last weekend, as I was waiting for the start of the performance of the Cleveland Orchestra at its summer outdoor...
2011-08-31
1,785 reads
As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief...
2011-08-22
758 reads
For the last year and a half or so I've been presenting a session on how to gather perfmon data...
2011-08-21
2,358 reads
Last fall, and winter, and spring I was part of the PASS Election Review Committee. It was interesting, sometimes fun,...
2011-08-11
616 reads
The IT Con event this Saturday, June 18, is an event similar to SQL Saturday. It has three tracks, an...
2011-06-16
763 reads
Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking "Does anyone have a script to...
2011-06-03
6,101 reads
Security is an important consideration when designing a database application. Who can get access to what data? How much damage...
2011-05-31
2,106 reads
Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I...
2011-05-26
1,269 reads
Over time it's easy to lose track of the things you set up to get work done. As a consultant,...
2011-05-25
1,206 reads
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
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