I am excited to share an important milestone in my life. My third book, “Administering Relational Databases on Microsoft SQL“, is released. Co-authored with Ahmad Yaseen and Rajendra Gupta,...
2021-04-19 (first published: 2021-03-09)
606 reads
A detail paradigm to support SQL on Azure cloud, DP 300 study guide, and explore the hidden side of cloud databases. Administering Relational Databases on Microsoft Azure takes readers...
2021-03-21
59 reads
?????????????????????? ???? ??????’?? ?????? ???? ?????????? ?????????????????? I have a very important announcement to make to all of you. Today on my birthday(16th March), I feel delighted and proud...
2021-03-16
27 reads
Introduction Ad hoc distributed queries use the OPENROWSET and OPENDATASOURCE functions to connect to remote data sources that use OLE DB. As the name suggests, ad-hoc distributed queries should...
2021-01-04
301 reads
Introduction The real-time data representation often requires quality content. In most cases, users flooded with multiple options or methodologies that may overwhelm the user to opt for the right...
2020-10-30
18 reads
Introduction The real-time data representation often requires quality content. In most cases, users flooded with multiple options or methodologies that may overwhelm the user to opt for the right...
2020-10-30
10 reads
It is not unknown to the SQL users that some of the SQL Server versions have become outdated. This is the main reason why most of the SQL Server...
2019-06-11
225 reads
It is not unknown to the SQL users that some of the SQL Server versions have become outdated. This is the main reason why most of the SQL Server...
2019-06-11
14 reads
Maintaining the SQL server database is always the first priority of the SQL administrators. But sometimes SQL database users have to face Microsoft SQL server error 5243 and error...
2019-05-21
222 reads
Maintaining the SQL server database is always the first priority of the SQL administrators. But sometimes SQL database users have to face Microsoft SQL server error 5243 and error...
2019-05-21
16 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