Leading Wildcards Aren’t A Good Default
SQL Server has LIKE, which lets us do various pattern matches, but most commonly we use the percent side as...
2011-03-05
1,165 reads
SQLAndy
Presenting in West Palm Beach on March 22, 2011
I’m pleased to be joining the West Palm Beach .Net group on March 22 to do a presentation on SQL...
2011-03-04
886 reads
The Power And Pain of Process–Part 1
Part of why I love IT is finding patterns and creating new ones. Patterns by themselves are interesting, but when...
2011-03-04
1,143 reads
Firefox and NTLM Authentication
By default Firefox doesn’t pass through NT credentials, not a big deal when you’re browsing Amazon by a big pain...
2011-03-01
933 reads
JTDS & Grails
Recently I had the chance to do some tuning on a system that was built using Grails (formerly Groovy on...
2011-02-28
2,475 reads
PASS Update #53 (Bylaws)
This week we posted some pending changes to the PASS bylaws. We try to do a review at least once...
2011-02-25
1,563 reads
A Plug for Wirefly
Wirefly is a website devoted to purchasing cell phones and plans. I found it when I was researching my Droid...
2011-02-22
850 reads
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
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
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
Blogs
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...
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
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