May 2010 S3OLV Meeting Recap
On the evening of May 13th, S3OLV held its monthly meeting. We had some really good discussion, and got to...
2010-05-14
688 reads
Jason Brimhall
Exceptional DBA
It is once again that time of year. It is time to nominate the DBA in your life for the...
2010-05-11
922 reads
May UG Meeting
This is just a quick note to remind any interested parties that the May S3OLV meeting will be held this...
2010-05-11
464 reads
T-SQL Tuesday #006: A Blobbing We Will Go
Once again it looks like I was early for the T-SQL Tuesday event. Last month I submitted my entry on...
2010-05-11
873 reads
SQL 2005 TableSpace
In the first post of this series I highlighted and described two stored procedures that are shipped from Microsoft. These...
2010-05-05
4,689 reads
Table Sizes
In SQL Server there are two stored procedures that help one to determine the size of a table. One is...
2010-05-03
864 reads
Marathon Schedule
Finally I am putting down to paper my marathon race list for this season. Some of my favorite races are...
2010-04-30
1,476 reads
BLOB Index Columns
For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database. I...
2010-04-27
1,223 reads
Index Stats Duplication
I came across a recent posting about seeing multiple entries in sys.dm_db_index_usage_stats for the same index. This kind of behavior...
2010-04-22
2,089 reads
SQL 2008 R2
Really short post here. I just found out that Stacia Misner (blog |blog 2 | @StaciaMisner) and Ross Mistry have released...
2010-04-21
564 reads
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Comments posted to this topic are about the item When Page Prefetching Takes a...
Question of the Day
Changing the Recovery Time
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