Reblog: How I prepared myself for the MCSE certification
SQLKover update: this was one of the most popular posts on my old blog. It’s quite old now and SQL...
2015-08-20
1,060 reads
SQLKover update: this was one of the most popular posts on my old blog. It’s quite old now and SQL...
2015-08-20
1,060 reads
Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If...
2015-08-13
795 reads
I was creating an SSIS catalog at a new project, but I was greeted with the following error message when...
2015-08-13 (first published: 2015-08-10)
4,836 reads
Recently I tried to open a script component in SSDT-BI 2013. I was developing for SSIS 2014, so this means...
2015-08-11
1,026 reads
Recently I had to create a new business intelligence project at a client. However, there was no source control present....
2015-08-07
2,501 reads
SQLKover update:when of the stranger Oracle issues I encountered over the years. Some time after I published the original blog...
2015-08-06
798 reads
As I mentioned in the blog post Speaking at SQL Server Days 2015, I’ll be giving a session at the...
2015-08-04
615 reads
SQLKover update:1.5 year later, I still stand by my position: Star Schema The Complete Reference is the best book on...
2015-07-30 (first published: 2015-07-23)
2,198 reads
SQLKover update: I’m reblogging this a bit earlier (it’s a quite recent blog post) because I still see people with this...
2015-07-30
1,024 reads
It’s the second tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know...
2015-07-17 (first published: 2015-07-13)
2,411 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