The format of sysssislog in SSIS 2005 and 2008 isn't great for human consumption, so what follows is an attempt to reformat it for easier digestion. It isn't perfect...
2011-04-26
3 reads
The format of sysssislog in SSIS 2005 and 2008 isn't great for human consumption, so what follows is an attempt to reformat it for easier digestion. It isn't perfect...
2011-04-26
4 reads
Checkpoints in SSIS are a great tool and they definitely have their place. The downside to them is that they...
2011-04-25
1,095 reads
For Day 25 of this series, I want to talk about how you go about picking a CPU for your...
2011-04-25
535 reads
I had a need today to disable all of our admin jobs while I moved our admin database to another...
2011-04-25
2,820 reads
Most of the time when I run a poll on my blog, I run it for at least a month...
2011-04-25
2,486 reads
A sad weekend, and shocking news Sunday morning. I was out running errands when I checked email and found out...
2011-04-25
1,587 reads
Day 25 RMO I have observed that no body has written anything about RMO. And replications is one of my...
2011-04-25
382 reads
You’ve set up your access to a SQL Azure site so you’re ready to go. Now how do you get...
2011-04-25
1,518 reads
I have blogged before about my appreciation for the SQL community mainly within the PASS organization as that is what...
2011-04-25
526 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