Indexed views on any core SQL server edition-The video
A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to...
2015-10-10
2 reads
A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to...
2015-10-10
2 reads
A few months back I created a blog post showing that you can indeed create and use indexed views on...
2015-10-10
448 reads
Crikey, where did that time go! I have been so busy adjusting to my new work life style I have...
2015-10-09
181 reads
Crikey, where did that time go! I have been so busy adjusting to my new work life style I have completely neglected my blog.. Well now that I seem...
2015-10-09
3 reads
Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t...
2014-12-26 (first published: 2014-12-19)
1,553 reads
Working with a sequence of attributes in XQuery is fairly straight forward with the 'attribute' axis even if you don't...
2014-12-19
803 reads
I recently blogged about how good I thought Trello was and shortly afterwards I found out that they did provide...
2014-11-12
294 reads
This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for...
2014-11-12
409 reads
This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for...
2014-11-12
145 reads
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-11-06 (first published: 2014-10-27)
18,635 reads
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
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
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