A SQL Server Hardware Nugget A Day – Day 14
Since 2006, Intel has adopted a Tick-Tock strategy for developing and releasing new processor models. Every two years, they introduce...
2011-04-14
596 reads
Since 2006, Intel has adopted a Tick-Tock strategy for developing and releasing new processor models. Every two years, they introduce...
2011-04-14
596 reads
For Day 13 of this series, we will cover Intel Turbo Boost Technology. This is not like the the old...
2011-04-13
498 reads
In Day 12 of this series, we will be talking about AMD Opteron Processor Numbering. Advanced Micro Devices (AMD) has...
2011-04-12
742 reads
I have added two new queries to this month’s version, to try to collect some more hardware information about the...
2011-04-11
492 reads
For Day 11, I want to talk about the new processor numbering system for Xeon processors that Intel introduced on...
2011-04-11
372 reads
Wow, we are 1/3 of the way through this series! Today’s post is “Classic Intel Xeon Processor Numbering Explained”. By...
2011-04-10
354 reads
For Day 9 of my SQL Server hardware series, I want to give my current recommended AMD Processor List for...
2011-04-10
591 reads
For Day 8 of my SQL Server hardware series, I want to give my current recommended Intel Processor List for...
2011-04-08
417 reads
I will be presenting my Dr. DMV presentation for the St. Louis SQL Server User’s Group on April 19. Here...
2011-04-07
1,128 reads
For Day 7 of this series, I will talk about the incredibly useful CPU-Z utility, which is available for free...
2011-04-07
1,304 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