Day 28 of 31 Days of Disaster Recovery: Recovering SQL if the Tempdb Drive Dies
Welcome to day 28 of my series 31 Days of Disaster Recovery. Today I want to talk about recovering SQL...
2013-02-22 (first published: 2013-02-14)
2,878 reads
Welcome to day 28 of my series 31 Days of Disaster Recovery. Today I want to talk about recovering SQL...
2013-02-22 (first published: 2013-02-14)
2,878 reads
This past weekend was SQL Saturday #198 in Vancouver, B.C. It started off with a leisurely drive up to Vancouver...
2013-02-19
1,241 reads
Today is day 27 of my series 31 Days of Disaster Recovery, and I want to talk about restoring a...
2013-02-12
1,093 reads
My series 31 Days of Disaster recovery has been on hiatus due mostly to illness. I’ve been battling a chest...
2013-02-10
1,287 reads
Welcome back for day 26 of my series 31 Days of Disaster Recovery. Today I want to share a tale...
2013-02-10
1,114 reads
The SQLSoldier World Tour kicks off this next Friday when I head up to Vancouver, in British Columbia, Canada. I...
2013-02-10
1,090 reads
Welcome to day 24 of my 31 Days of Disaster Recovery series. Previously, I’ve talked about several different forms of...
2013-01-31
1,840 reads
It’s day 23 of my 31 Days of Disaster Recovery series, and today’s blog post is inspired from an email...
2013-01-29
1,577 reads
The end of the day is quickly approaching as I finish this blog post. This is day 22 in my...
2013-01-27
1,429 reads
Welcome back for day 21 of my 31 Days of Disaster Recovery series. Today I want to talk about trying...
2013-01-26
1,506 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