A SQL Experiment – Mentoring
News Flash The SQL Community is about to get stronger. Why? There is a great new initiative that was recently launched. Steve Jones and Andy Warren are teaming up...
2011-04-26
8 reads
Blog Posts
A SQL Server Hardware Nugget A Day – Day 26
For Day 26 of this series, I want to talk a little about laptop processor selection (since I get a...
2011-04-26
1,235 reads
Daily Denali Delight – Day 4
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-26
964 reads
MS Certs Exam price is rising ...
Today Marlon Ribunal twittes come with new info about MS Certifications exams are rising...
This is not a good news, so...
2011-04-26
912 reads
Powershell Day 26
Day 26 Generate script Generate script for sql server objects is very simple, there are different ways we can generate...
2011-04-26
664 reads
Replication Monitor – Friendly Names
You may have noticed when you setup a merge pull subscription using the
New Subscription Wizard in SSMS that you...
2011-04-26
1,391 reads
Search Stored Procedure Text
There will come a day, if it has not already come and gone, when you will want to search through...
2011-04-26
1,063 reads
SQL Azure Diagnostic Tool
One of the CSS Engineers from Microsoft has released a diagnostic tool for SQL Azure. It’s worth a look. It’s...
2011-04-26
1,012 reads
SQL University: Who has access to my SQL Server?
Welcome to PowerShell Week #2 for SQL University! One of the frequent questions I hear is, "Who has access to...
2011-04-26
2,783 reads
Transforming SSIS' sysssislog Entries Into Something More Readable
The format of sysssislog in SSIS 2005 and 2008 isn't great for human consumption, so what follows is an attempt...
2011-04-26
1,944 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