Day 20 of 31 Days of Disaster Recovery: The Case of the Backups That Wouldn’t Restore
I have decided to spend day 20 of my 31 Days of Disaster Recovery series by relating a true tale...
2013-01-25
1,134 reads
I have decided to spend day 20 of my 31 Days of Disaster Recovery series by relating a true tale...
2013-01-25
1,134 reads
Today is day 17 of 31 Days of Disaster Recovery. The series has skipped a couple of days due to...
2013-01-24 (first published: 2013-01-21)
1,847 reads
It’s day 19 of my 31 Days of Disaster Recovery series, and today I want to talk about how much...
2013-01-24
1,182 reads
Day 18 of my 31 Days of Disaster Recovery series is drawing to a close. It’s 11:22 PM here, and...
2013-01-23
1,183 reads
It’s day 16 of my series 31 Days of Disaster Recovery. I’ve seen a lot of great DR related posts...
2013-01-18
903 reads
Welcome back to my 31 Days of Disaster Recovery series. Today is day 15, and I want to answer a...
2013-01-17
1,411 reads
Welcome to day 14 of my 31 Days of Disaster Recovery series. I’ve previously discussed handling corruption for nonclustered indexes...
2013-01-16
2,226 reads
31 Days of Disaster Recovery
Today’s post took longer to prepare than I had anticipated which is why day 13...
2013-01-15
1,439 reads
31 Days of Disaster Recovery
Welcome back to my series 31 Days of Disaster Recovery. Today is day 11, and...
2013-01-12
3,785 reads
31 Days of Disaster Recovery
Fittingly, today’s focus on disaster recovery as part of my 31 Days of Disaster Recovery...
2013-01-12
1,325 reads
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Comments posted to this topic are about the item Cleaning Up the Cloud
Comments posted to this topic are about the item The Maximum Value in the...
Comments posted to this topic are about the item Oracle Performance Tuning: Practical Techniques...
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON INSERT dbo.TravelLog ( TravelLogID, CityID, StartDate, EndDate ) VALUES (25, 5, '2025-09-12', '2025-09-17') SET IDENTITY_INSERT dbo.TravelLog OFFI now run this code.
DBCC CHECKIDENT(TravelLog) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-10-14', '2025-10-17') GOWhat is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025? See possible answers