Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by the urgent of any sort. Focus on the important. The urgent is a tyrant. –...
2025-06-27 (first published: 2025-06-13)
434 reads
I had someone ask me about using triggers to detect changes in their tables. This is a second post looking at triggers, in this case, modifying my trigger to...
2025-06-11
63 reads
This month we have a great invite from Joe Fleming, a first time host of T-SQL Tuesday. Joe reached out when I requested some hosts and I’m glad he...
2025-06-10
95 reads
One of the biggest challenges with monitoring data is managing the volume over time. Lots of bespoke/home-grown solutions don’t do this well, and some commercial products have a gross...
2025-06-09
28 reads
Redgate has been known for many useful tools that are easy to use. We’ve tried to do that in all our point tools. We talk about simplicity all the...
2025-06-13 (first published: 2025-06-06)
274 reads
I had someone ask me about using triggers to detect changes in their tables. As I explained a few things, I thought this would make a nice series, so...
2025-06-04
24 reads
I wrote an editorial on the view of GenAI tech from execs and someone commented that they wanted references for results. Most of us might take a result from...
2025-06-02
22 reads
I read Brent’s first look at SSMS and Copilot in there. He didn’t have a great opinion of the tool, especially comparing it to Gemini or Claude. I haven’t...
2025-05-30
85 reads
falesia– n. the disquieting awareness that someone’s importance to you and your importance to them may not necessarily match – that your best friend might only think of you...
2025-05-30
9 reads
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) AS RN FROM wp_posts WHERE post_parent = 94341; ) UPDATE p SET...
2025-05-28
130 reads
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
Comments posted to this topic are about the item When Page Prefetching Takes a...
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