I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...
2013-04-12 (first published: 2013-04-01)
4,178 reads
I see this question in one form or another a lot. I’ve seen this or something like it probably half...
2013-04-08
758 reads
This is an uncommon task but one that does turn up every once in awhile. A SQL login has to...
2013-04-03 (first published: 2013-03-25)
9,437 reads
Templates are one of those really handy tools that most DBAs I know of have either never heard of or...
2013-03-18
1,156 reads
While I was at the 2011 Pass Summit I was given the following piece of code to create a comma...
2013-03-14
894 reads
I was scanning http://dba.stackexchange.com and ran across the following question:
http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory
Basically the OP wanted to know how to get rid of...
2013-03-12 (first published: 2013-03-01)
4,159 reads
When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic...
2013-03-05 (first published: 2013-02-25)
5,056 reads
If you are lucky you’ve never seen an error along the lines of:
The SELECT permission was denied on the object...
2013-03-04
994 reads
The INSERT command has two distinct ways to load data into a table.
INSERT INTO Table (field1, field2) VALUES ('string1','string2')And
INSERT INTO...
2013-02-28
3,417 reads
Anyone who has been reading my blog for a while should realize that several divisions in my company have been...
2013-02-18
1,015 reads
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
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...
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