What’s New In Denali for SSRS
I was so excited when I found out that Denali was released last week. Like it was Christmas time, I...
2010-11-23
589 reads
I was so excited when I found out that Denali was released last week. Like it was Christmas time, I...
2010-11-23
589 reads
I was so excited when I found out that Denali was released last week. Like it was Christmas time, I...
2010-11-16
471 reads
Write this down… No really… Write it, print it, send it to all of your friends and loved ones. J...
2010-11-15
377 reads
I have never had the opportunity to go to PASS before, but even though I was unable to attend this...
2010-11-15
327 reads
I was creating an SSIS package recently and ran into the “TargetInvocationException: Exception has been thrown by the target of...
2010-11-12
702 reads
Recently, a friend of mine asked me how he could have the date appended to the end of a file...
2010-11-09
13,531 reads
I enjoy blogging. I enjoy passing on the information that I have gathered over the years. I also enjoy doing...
2010-11-09
596 reads
I recently became aware of a special hack in Windows 7. It is called GodMode and can very simply be...
2010-11-09
653 reads
Unlike fine wine, you typically wouldn’t want your statistics to be aged. At least for tables that are being updated...
2010-11-08
3,068 reads
Brian K. McDonald
SQLBIGeek
Twitter: @briankmcdonald
Welcome to the third post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am...
2010-11-06
533 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