Congrats to DCAC Staff on MVP Renewals
July 1st is a day all Microsoft Most Valuable Professionals (MVP) wait patiently at their computers hitting F5 over and...
2018-07-02
326 reads
July 1st is a day all Microsoft Most Valuable Professionals (MVP) wait patiently at their computers hitting F5 over and...
2018-07-02
326 reads
I typically don’t write opinion posts, but given recent events I thought it was important to follow up on one of my tweets....
2018-06-29 (first published: 2018-06-14)
2,259 reads
Ever seen the below error? Until this week I hadn’t. So, I figured I’d take a little time and introduce...
2018-06-28 (first published: 2018-06-20)
10,249 reads
A few weeks ago, I wrote Part 1, 2 and 3 of this series, which was a beginner’s guide to Always Encrypted. In part...
2018-06-25 (first published: 2018-06-13)
2,570 reads
Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and...
2018-05-30
581 reads
Sometimes people speak “SQL” and expect you know all the terminology. In recent a conversation about query plans I was...
2018-05-24
814 reads
In SQL Server the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The...
2018-05-02
362 reads
Ever look back at old work and wonder what was I thinking when I did that? Or even better you...
2018-04-25
326 reads
In my sessions, I always talk about how to build your skill set when you don’t have a budget for...
2018-04-18
532 reads
Sometimes as a newbie to SQL Server using SQL Server Management Studio (SSMS) you don’t know about the little gold...
2018-03-27
490 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