Introducing SQL Operations Studio
Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did...
2017-11-29
698 reads
Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did...
2017-11-29
698 reads
In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because...
2017-11-22
341 reads
For the last five months or so, I have been helping some really smart people put words on paper, both...
2017-11-15
569 reads
Ewald Cress writes: Find a person or several people to pick on, and tell us a shareable story or two...
2017-11-14
322 reads
I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t...
2017-11-08
330 reads
I have a favourite new feature of SQL Server Management Studio 17.3 (SSMS), and that’s XE Profiler, which allows you to...
2017-11-01
492 reads
This is more for my benefit in the future, but hopefully it can help someone else too. We recently had...
2017-10-25
4,269 reads
Recently, I was asked to assist an organization with getting their data back for a SQL Server that had experienced...
2017-10-18
620 reads
In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to...
2017-10-11
456 reads
For a few years now, Microsoft has augmented its irregular release of Service Packs with a more frequent Cumulative Update...
2017-10-04
441 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