MDX Puzzle #5
Writing YTD totals and Running totals using T-SQL can take a little effort. However, with MDX it's not too difficult. ...
2010-08-01
545 reads
Patrick LeBlanc
MDX Puzzle #4 - Solution
This puzzle may not have been much of a challenge, but it introduced two new MDX concepts. I have to...
2010-07-30
1,546 reads
2010 3rd Quarter Goals
Now that we are into the third quarter of 2010 I decided to post an update of my 2nd quarter...
2010-07-28
1,007 reads
MDX Puzzle #4
This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with...
2010-07-28
548 reads
SQL Saturday Wiki
This past weekend I had the opportunity to hangout with some of the brightest upcoming SQL Server Professionals and a...
2010-07-25
598 reads
SQL Server 2008 R2 for the DBA Recording and PowerPoint
I recently had the opportunity to do two presentation on SQL Server R2 for the DBA. In the first session...
2010-07-23
528 reads
.NET speaker Idol, Guess who won?
Last night (July 21, 2010) I had the honor of being a speaker at the Baton Rouge .Net User Group. ...
2010-07-22
807 reads
Free Data Warehouse Training - SQL Lunch #27 Let's Get Dimensional
Join Adam Jorgensen, tomorrow on the SQL Lunch to learn about Dimensional Modeling. Go to SQL Lunch and add this...
2010-07-21
819 reads
SQL Server 2008 R2 for the DBA Webcast
Tomorrow at 11:00 AM EST I will be giving a talk on SQL Server 2008 R2 for the DBA. Here...
2010-07-21
497 reads
Practice Your PASS Session on the SQL Lunch
We at the SQL Lunch would like to extend an invitation to all of the PASS speakers. If you are...
2010-07-18
392 reads
Blogs
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
The Challenge of Implicit Transactions: #SQLNewBlogger
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
Forums
Compatibility levels on database changing them and impacts.
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
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
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