New Book on Query Optimizer
Benjamin Nevarez (blog) has been working really hard on a book on the Query Optimizer. It just got finished in...
2010-10-26
592 reads
The Scary DBA
Another Must See Session
I can’t believe I missed this one in all the posts and recommendations I’ve been making about great sessions coming...
2010-10-25
438 reads
SQL Rally Voting
I received word over the weekend that my precon application had made it past committee and was now subject to...
2010-10-25
606 reads
Who You Learn From
Less than two weeks to go until the PASS Summit. I’m excited. I’ve managed to cram a ton of activities...
2010-10-25
674 reads
Kilt Day at the PASS Summit
Last year, with the infinite power at my disposal (read, zero), I declared Wednesday, Kilt Wednesday at the PASS Summit. It took...
2010-10-20
1,431 reads
Upcoming Speaking Engagements
I’ve got a couple of more sessions before the big two at the PASS Summit. Tomorrow night, October 20th, I’ll...
2010-10-19
710 reads
Powershell is Really Easy… If you know what you’re doing
Sigh… I just spent almost a full work day trying to come up with, what turned out to be a...
2010-10-18
3,159 reads
Scary DBA Takes Over the World
Or, at least gets translated into Russian.
I realize I’m effectively a 10 year old, but, come on, HOW COOL IS...
2010-10-15
597 reads
Working the Door
You know those guys that work the door at clubs, seperating the wheat from the chaff, culling the herd, Choosing the Slain, sifting...
2010-10-14
710 reads
Speaking at SNESSUG
I’ll be presenting tonight at the Southern New England SQL Server Users Group (SNESSUG). The topic is “Using DMVs as...
2010-10-13
684 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