The Importance Of Managing Expectations
Have you ever taken a sip of sweet tea only to discover that it was soda instead? Eeww! What an eye-opening experience! Don’t misunderstand; I like soda. But when...
2011-02-18
7 reads
Blog Posts
What Should PASS Be? I Challenge You
PASS isn’t what it should be. I hear that a lot, and in many ways I agree with you. We’re...
2011-02-18
553 reads
DenverSQL UG Meeting: Tim Mitchell presents Dirty Data? Clean it up!
Denver SQL Server User Group - Thursday, February 17, 2011
Main Presentation
"Dirty Data? Clean It Up! By Tim Mitchell"Dirty Data? Clean It...
2011-02-17
455 reads
How to Interpret SELECT @@VERSION in SQL Server
One common point of confusion that I often see when people run the SELECT @@VERSION query is how to properly...
2011-02-17
1,540 reads
SQL Rally
I believe I’ve been far too quiet about this event.
In May, in Orlando Florida, there will be a two...
2011-02-17
644 reads
SQLServerPedia Blogger Awards
Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards. You...
2011-02-17
480 reads
SQLServerPedia Blogger Awards
Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards. You can read about that here. Of all of the...
2011-02-17
VSone session material
As I have announced in both of my sessions at the VSone conference in Munich, you
can find the session material...
2011-02-17
554 reads
Who Is This Super Hero?
We recently switched from Brighthouse to DirectTV and of the first things we did was to find the kids channels...
2011-02-17
561 reads
February 2011 JSSUG Meeting Tomorrow
Tomorrow, I will be presenting at the Jacksonville SQL Server Users Group (JSSUG) meeting. Please join me for my talk...
2011-02-16
426 reads
Blogs
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
The Challenge of Implicit Transactions: #SQLNewBlogger
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
SQL Server Is Slow – Part 2 of 4(?)
By Kevin3NF
The 10-Minute Outside-In Triage Don’t Blame SQL First It’s 9:05 AM and your helpdesk...
Forums
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Comments posted to this topic are about the item When Page Prefetching Takes a...
Question of the Day
Changing the Recovery Time
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