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,...
I've noticed several instances of what looks like a recursive insert with the format:...
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...
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