String or binary data would be truncated: get the full picture in SQL Server 2017
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server...
2018-10-31
504 reads
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server...
2018-10-31
504 reads
Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL...
2018-10-24
228 reads
Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration...
2018-10-17
291 reads
On Monday of this week, Microsoft announced changes to the servicing model for SQL Server, starting with SQL Server 2017....
2018-10-10
315 reads
Some time ago we started a new series here, called Database Fundamentals. The very first post in that series asked...
2018-10-03
283 reads
On Monday 24 September 2018, Microsoft announced a slew of stuff at their annual Ignite conference that is going to...
2018-09-26
346 reads
The Azure cloud platform lost a data centre for a number of hours recently due to inclement weather. This affected...
2018-09-19
225 reads
Fellow Canadian Doran Douglas brought this issue to my attention recently, and I wanted to share it with you as...
2018-09-12
289 reads
Content warning: This is the first of two rebuttal essays, about why someone is wrong on the Internet. It is...
2018-09-10 (first published: 2018-08-22)
3,147 reads
Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the...
2018-09-05
258 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