SQL Server Management Studio v17.0
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...
2017-05-10
230 reads
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...
2017-05-10
230 reads
By now you will have heard that the next version of SQL Server has been announced. There’s no release date yet,...
2017-05-03
92 reads
You’re reading this series of posts because you want to learn about databases and how to use them. What you...
2017-04-26
93 reads
Taking a short break from the Database Fundamentals series of the last few weeks, I’d like to mention some upcoming...
2017-04-19
112 reads
A friend of mine in the filmmaking business, who is exceedingly bright but has never worked with SQL Server before,...
2017-04-12
100 reads
If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system...
2017-04-05
108 reads
Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting...
2017-03-29
311 reads
Last week, we discussed storing text in a database. This week we will dive deeper into data types. When storing...
2017-03-22
103 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