Why use a Date Dimension Table in a Data Warehouse
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you...
2016-06-06 (first published: 2016-05-29)
7,109 reads
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you...
2016-06-06 (first published: 2016-05-29)
7,109 reads
SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more...
2016-04-23
633 reads
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice...
2016-03-16
566 reads
Next Meeting
Thu, Mar 24 2016 12:00 Central Daylight Time
Dustin Ryan presents What's New in Power BI
RSVP:https://attendee.gotowebinar.com/register/8425155555275941377
WHAT'S NEW IN POWERBI...
2016-03-16
537 reads
I will be speaking with other SQL Server experts for SQLSaturday #461 in Austin on Jan 30th, 2016. This is...
2016-01-18
469 reads
Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a...
2015-12-03 (first published: 2015-11-26)
3,286 reads
Please join Idera tomorrow for a #SQLChat on Twitter. The December #SQLChat will take place Tuesday, December 9 at 11...
2015-12-02
497 reads
I started using a product called SQL Diagnostic Manager from Idera about 10 years ago at a Home Health company....
2015-11-05
499 reads
Yes, it is that time of the year again. You know, when all the nut case and normal SQL Server...
2015-10-19
510 reads
On Wednesday morning, Conner Cunningham from Microsoft was the keynote speaker for IT/DevConnections in Las Vegas. His talk focused on...
2015-09-17
412 reads
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
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
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