Adventure Works Sample Database Diagrams
Most of my examples utilize either adhoc type of data samples or one of the versions of AdventureWorks. I do...
2011-02-27
2,841 reads
Brian K. McDonald
Quests Performance Monitor Counters Poster
I just wanted to take a moment to thank Kevin Kline, Brent Ozar, Christian Bolton, Bob Ward, Rod Colledge and...
2011-02-27
3,013 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
Redgate’s Free SQL Search Tool
I have been using this tool for quite a while and just remembered that I haven’t written a blog about...
2011-02-15
2,122 reads
SQL Rally: The Votes Have Been Tallied
First and foremost, I would like to send a sincere thank you to everyone who voted for my Reporting Services...
2011-02-10
587 reads
SQL Rally 2011 Voting - Reporting Services Boot Camp
All,
Since SQL Server Reporting Services 2005 came out, I have been working very close within the BIDS environment and every...
2011-01-31
1,536 reads
SQL Saturday Tampa Follow Up
This past weekend, I had a talk on SQL Server Reporting Services down in Tampa Florida for SQL Saturday 62....
2011-01-21
737 reads
My 2010 Year in Review
While in Cincinnati for the first time since September of 2007, I heard on several occasions that I work too...
2011-01-04
384 reads
My 2011 Aspirations
Yesterday, I posted a blog about my year in review for 2010. So, I thought that it would be a...
2011-01-04
437 reads
Pragmatic Works Seeking Employment Candidates
If you’re anything like me, you enjoy constantly striving to new levels of knowledge. This new level of knowledge brings...
2010-12-18
422 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