Is CPU-Z Risky To Run on a Production Server?
There was a conversation on Twitter recently (with the #sqlhelp hashtag) about whether it was completely safe to run the...
2011-02-19
1,773 reads
Blog Posts
SQL Saturday #70 - Columbia, SC 2011 Session Schedule Is Up!
As announced, we have posted our session schedule for SQL Saturday #70 - Columbia, SC. The event will be March 19, 2011...
2011-02-19
1,266 reads
Can You Dig It? – Plan Cache Series
She can dig it!
D Sharon PruittA few PASS Summit’s ago, I became interested in the information available in the...
2011-02-18
573 reads
I'm in at SQL Connections!
At the end of March I'll be journeying down with the family to Orlando, Florida. We plan on stopping in...
2011-02-18
944 reads
Intro to SSAS BI Workshop - Review
A Synopsis of My Experiences of the “Intro to SSAS” BI Workshop in NYC!
By Robert Pearl
Well it’s a wrap of...
2011-02-18
1,836 reads
Notes from the February 2011 MagicPASS Meeting
I attended the second meeting of MagicPASS (no web site yet) on Feb 16 at Stetson University in Celebration, FL....
2011-02-18
552 reads
PowerPointShell
I wanted to add a neat demo to my .NET Powers Activate! Form of PowerShell! presentation that would really demonstrate...
2011-02-18
514 reads
Renumbering Rows in a Table Variable (or Table/Temp Table)
I was recently working on a data cleanup problem where I had to do lots of comparisons of one row...
2011-02-18
4,277 reads
SSWUG Free SSIS Expo – Today!
SSWUG Free Expo Event: Basic and Complex SSIS Features virtual conference is today! There’s a chance that you can probably...
2011-02-18
683 reads
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
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