What is a good Disaster Recovery Plan?
During a Q&A session I hosted at our local Calgary SQL Server User Group last month, one of the attendees...
2017-07-19
150 reads
During a Q&A session I hosted at our local Calgary SQL Server User Group last month, one of the attendees...
2017-07-19
150 reads
Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing...
2017-07-12
151 reads
We can easily spend tens of thousands of dollars on core licences for SQL Server, and then we go and...
2017-07-05
172 reads
The Database Fundamentals series is now done. We started with understanding what a database is, and then spent a little...
2017-06-28
345 reads
In 2017, there’s no excuse not to have at least a testing environment, and preferably a development environment as well,...
2017-06-21
131 reads
My First DELETE Statement Here are the links to the previous posts in this series: My First SELECT Statement My...
2017-06-14
142 reads
My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This...
2017-06-07
130 reads
My First INSERT Statement Last week we covered how to get information out of a table, using a SELECT query....
2017-05-31
390 reads
My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management...
2017-05-24
160 reads
When we want to retrieve information from a database, we query the structure with language appropriate to the database. Remember...
2017-05-17
100 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