2012-06-06
3,081 reads
2012-06-06
3,081 reads
Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005
2011-02-18 (first published: 2009-09-15)
54,478 reads
If any of you follow me on SQLServerCentral.com, then you know I recently started a new job. Well, after two...
2010-08-26
1,687 reads
On June 1, 2010, Steve Gray had an article, Sins of SQL: The Time Table, published on sqlservercentral.com. I’m not...
2010-06-03
2,577 reads
2010-04-30
3,428 reads
This is not a technical post, it’s personal, but I need to express my fears. It isn’t about our economy,...
2010-04-01
1,556 reads
Building a tally table is a common T-SQL problem that many new developers struggle with. Lynn Pettis brings us an article that shows how to use CTEs to accomplish this.
2009-09-22
11,104 reads
Okay, my second article which was originally published on sswug.org, is now available on SQLServerCentral.com. This article compares two methods...
2009-09-21
1,252 reads
Well, the first of two articles I originally had published on sswug.org will be published on ssc tomorrow. I'm looking...
2009-09-14
1,499 reads
I realize I have been relatively quiet for a while, but summer is actually a fairly busy time for us...
2009-08-22
1,208 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