A Small Collection of SQL Azure Queries
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
2011-03-11
2,531 reads
Glenn Berry
SQL Server Videos on Channel 9 From Microsoft
Here is a collection of 13 short (less than 10 minutes each) videos about improvements in SQL Server Denali, and...
2011-03-09
1,836 reads
Las Vegas SQL Server User’s Group Presentation on March 10
I will be giving a virtual presentation via LiveMeeting on March 10, 2011. The S3OLV User Group meeting starts at...
2011-03-09
638 reads
Visual Studio 2010 SP1 Released
Microsoft has released the RTM version of Visual Studio 2010 SP1, which is available on the MSDN Subscribers web site.
Microsoft’s...
2011-03-08
751 reads
March 2011 Version of SQL Server 2005 and 2008 Diagnostic Queries
Another month, and another new version of my SQL Server Diagnostic Information queries for both SQL Server 2005 and SQL...
2011-03-08
645 reads
SQL Server Hardware Selection Presentation from Rocky Mountain Tech Trifecta
I just wanted to post a link to my presentation on Hardware 201: Selecting and Sizing Database Hardware for OLTP...
2011-03-05
509 reads
SQL Server 2008 R2 RTM Cumulative Update 6 Released
Microsoft actually released SQL Server 2008 R2 Cumulative Update 6 on February 21, 2011, so I am a little late...
2011-03-01
1,065 reads
Rocky Mountain Tech Trifecta on March 5
I will be attending and speaking at the Rocky Mountain Tech Trifecta in downtown Denver on March 5, 2011. This...
2011-03-01
495 reads
Don’t Be Afraid of Windows Failover Clustering!
One of the more exciting features in SQL Server code-named “Denali” (which is the current official name for the next...
2011-02-28
1,857 reads
Some Suggested SQL Server 2008 R2 Instance Configuration Settings
Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level...
2011-02-25
13,763 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