Dates and Times in SQL Server: DATENAME()
Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many...
2018-06-20
900 reads
Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many...
2018-06-20
900 reads
In my previous posts in this series we’ve seen reference to Transact-SQL (T-SQL) functions that are used to get the...
2018-06-13
288 reads
I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in...
2018-06-06
1,139 reads
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed...
2018-05-30
437 reads
Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL...
2018-05-23 (first published: 2018-05-16)
3,880 reads
Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During...
2018-05-23
473 reads
Thank you! Thank you for reading my blog. Thank you for buying my book. Thank you for attending my sessions...
2018-05-09
244 reads
It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP...
2018-05-02
263 reads
We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data...
2018-04-25
385 reads
Last time, we began an in-depth look at how time is measured. This post continues our journey. If any of...
2018-04-18
479 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