IP and Default Trace…T-SQL Tuesday #005 - A week early - D'oh
As chance would have it, I had been checking Adam’s blog daily for the last few days to find the...
2010-04-06
1,757 reads
Blog Posts
Is Anybody Using That Stored Procedure?
Introduction
From time to time I get asked to check if a stored procedure is still used in preparation for dropping...
2010-04-06
481 reads
LV April SQL Users Group Meeting
S3OLV or SSSOLV will be holding our meeting Thursday April 8th. The User Group is in affiliation with PASS and...
2010-04-06
457 reads
PASS Update #28 (SQLSaturday Transition)
We’ve been busy on the transition and we’re finally at a place where we can give you an update on...
2010-04-06
352 reads
SCSUG April Meeting Reminder
A reminder to anyone in the Brevard County Florida area:
The SCSUG monthly meeting is at 6:30 on Thursday, April...
2010-04-06
290 reads
Swing and a Miss
I missed my first newsletter today. It wasn’t until I went to schedule tomorrow’s that I realized I hadn’t sent...
2010-04-06
361 reads
Uninstall 64 bit and reinstall 32 bit SQL Server
For reason's beyond the scope of this post I needed to uninstall a 64 bit version of SQL server standard...
2010-04-06
2,455 reads
What I Do to Prep a Technical Presentation
This was a question asked on Twitter the other day, "How do folks prepare for a presentation?" Here are some...
2010-04-06
794 reads
Writing With More Than One Voice
I’ve been blogging for a couple of years now and have slowly settled into the style and pattern of blogging...
2010-04-06
298 reads
A DMV a Day – Day 5
The DMV for Day 5 is sys.dm_db_mirroring_auto_page_repair, which is described by BOL as:
Returns a row for every automatic page-repair attempt...
2010-04-05
1,017 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
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...
Forums
Arc Enabled SQL Server
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
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
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