SQL Statistics – another Spin
I was reading a blog by Pinal Dave that was about using catalog views to obtain information about stats for...
2011-07-01
662 reads
SQL RNNR
SQL Statistics – another Spin
I was reading a blog by Pinal Dave that was about using catalog views to obtain information about stats for the entire database. While reading the blog, I was...
2011-07-01
13 reads
Arggghhhhh
I have a new tune stuck in my head now. It got stuck there this afternoon shortly after my computer...
2011-06-30
1,631 reads
Arggghhhhh
I have a new tune stuck in my head now. It got stuck there this afternoon shortly after my computer was forced into a reboot. I was in the...
2011-06-30
3 reads
70-450 Study Guide
In my last post concerning my certification journey I said I may post a study guide. I have thought it...
2011-06-30
4,762 reads
70-450 Study Guide
In my last post concerning my certification journey I said I may post a study guide. I have thought it over and a sweetened condensed version of some of...
2011-06-30
2 reads
MCITP: 3 Down 1 To Go
Despite my desire to do one exam a week in pursuit of the MCITP Certifications for DBA and Developer in...
2011-06-27
757 reads
MCITP: 3 Down 1 To Go
Despite my desire to do one exam a week in pursuit of the MCITP Certifications for DBA and Developer in SQL 2008, other things came up that have slowed...
2011-06-27
T-SQL Tuesday #19 – Disasters & Recovery
When I first read this article, I thought to myself “I have no clue on this one. What could I...
2011-06-14
728 reads
T-SQL Tuesday #19 – Disasters & Recovery
There are three types of disasters that are seldom expected. Read about the fun of dealing with these different types of disasters.
Related Posts:
The Mystery of Missing Backup Files December...
2011-06-14
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
Recursive Select - What is this really doing
I've noticed several instances of what looks like a recursive insert with the format:...
Cleaning Up the Cloud
Comments posted to this topic are about the item Cleaning Up the Cloud
The Maximum Value in the Identity Column
Comments posted to this topic are about the item The Maximum Value in the...
Question of the Day
The Maximum Value in the Identity Column
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 OFF
I now run this code.
DBCC CHECKIDENT(TravelLog)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-10-14', '2025-10-17')
GO
What is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025?
See possible answers