PASS Summit 2011 Session Preference Survey
PASS has added a new feature to the session selection process for the PASS Summit 2011, which they are calling...
2011-05-11
595 reads
Blog Posts
PASS Summit Session Selection is Open
This year the Program Committee decided to open up the selection process to the community. I'm anxious to see how...
2011-05-11
848 reads
Patch Week
My email account started getting notices of Windows patches yesterday, indicating it’s patch week again. If you manage Windows devices,...
2011-05-11
891 reads
Pragmatic Tools Week: Task Factory
If you've ever spent any time doing SSIS development work, you'll eventually come to a point when developing something and...
2011-05-11
1,426 reads
SQLRally Overdrive: Birds of a Feather Discussions Event
Just wanted to post a quick note/invitation to everyone to come join us on Thursday, May 12th from 5:45-7:00 for...
2011-05-11
365 reads
Troubleshooting Performance -1
Whenever you get a call from user that they are facing any performance issue what would you do. As I...
2011-05-11
467 reads
TSQL Tuesday #18 - Using CTE to Analyze Disk IO
(TSQL Tuesday on Wednesday! - Apologies for the late entry - better late than never)
Today’s topic is CTE’s.Scientifically speaking, solids mostly expand...
2011-05-11
2,004 reads
T-SQL: Identifying, inserting and removing spaces in strings
Frequently, when working with strings you will need to identify, insert or remove spaces before, after or in between characters.
For example, you may...
2011-05-11
3,744 reads
Vote for My PASS Summit Sessions
Yes, this is absolutely a shameless post for self-promotion. However, since potential attendees get to offer input into what sessions...
2011-05-11
952 reads
100% Microsoft?
Reprinted from my editorial in Database Weekly.
When I was a junior DBA many years ago (even before the company I...
2011-05-10
559 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