AlwaysOn: Configuring Secondary Read-Only Access
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-10 (first published: 2012-02-08)
10,060 reads
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-10 (first published: 2012-02-08)
10,060 reads
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-08
1,078 reads
I have been quiet over the past year trying to get acclimated to my new job and my new found work...
2012-02-03 (first published: 2012-02-02)
1,399 reads
I have been quiet over the past year trying to get acclimated to my new job and my new found...
2012-02-02
386 reads
During a recent customer engagement I was asked if it was possible to ensure that the colors in a Line...
2012-01-10
1,599 reads
I am excited to announce that I will be giving a virtual presentation to the Knoxville SQL Server User Group. ...
2012-01-04
987 reads
If you are in and around Dallas next week drop by my FREE half-day Business Intelligence workshop. The details are...
2011-11-01
1,666 reads
One of the less advertised enhancements of SSIS in SQL Server 2012 is the Project Reference type available when using...
2011-10-24
3,240 reads
So recently I was doing a demonstration using the new SQL 2012 SSIS running in Visual Studio 2010. I needed...
2011-10-13
32,463 reads
When working at large organizations with several users, managing security using Windows or SQL authentication could be challenging. However, there...
2011-10-13
9,783 reads
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
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
Comments posted to this topic are about the item When Page Prefetching Takes a...
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