How To Write Better Queries WebCast
One character. That’s all it takes; just one character in a Transact-SQL query can make the difference between an index seek and an index scan. Transact-SQL is easy to learn....
2011-02-22
4 reads
Blog Posts
How To Write Better Queries WebCast
One character. That’s all it takes; just one character in a Transact-SQL query can make the difference between an index seek...
2011-02-22
806 reads
Shameless Self-Promotion - Introduction to SQL Server [Book]
My introductory text to SQL Server, appropriately titled Introduction to SQL Server, is now in print and available for sale. The...
2011-02-22
945 reads
SQL Saturday 67 Chicago Pre-con
We have big news for SQL Saturday #67 Chicago. There is going be a pre-con on Friday 3/25 at the Hampton Inn right around the corner from the SQL...
2011-02-22
10 reads
SQL Saturday 67 Chicago Pre-con
We have big news for SQL Saturday #67 Chicago. There is going be a pre-con on Friday 3/25 at the...
2011-02-22
931 reads
SQLDIY: Manage and Monitor SQL Server Yourself
As an old school DBA and always having cheap frugal employers, I have rolled my own management and monitoring solutions....
2011-02-22
570 reads
SQLskills Immersion Event on Internals and Performance – Day 1
Sonny Bryans Smokehouse Bbq would make an interesting classroom
Today was the first day of my first SQLskills event. The event...
2011-02-22
437 reads
T Minus Three Days to the MCM Test
I take the MCM test on Friday. I’ve been watching videos and reading white papers and blogs for the last...
2011-02-22
1,358 reads
What Should PASS Be?
Andy Warren posted a question the other day (well, issued a challenge actually), “What Should PASS Be?” I’ll let you...
2011-02-22
710 reads
A Wireless Production Server? Sure, Just Enable the Wireless Networking Feature on Windows 2008
Since I have Enabled Wireless on Windows Server 2008, and picked up a better-than-average Asus N wireless card, handling the...
2011-02-21
792 reads
Blogs
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,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
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