SQL RNNR

Blog Post

Find Index Create Date

This article shows a quick script to help determine indexes that were created recently. This script will help you out of rough spot and help reduce the chance of...

2019-12-25

345 reads

Blog Post

Find Index Create Date

This article shows a quick script to help determine indexes that were created recently. This script will help you out of rough spot and help reduce the chance of...

2019-12-25

4 reads

Blog Post

Ad Hoc Queries Disabled

This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.
Related Posts:

Linked Servers and Stats October 17,...

2020-01-02 (first published: )

1,361 reads

Blog Post

Ad Hoc Queries Disabled

This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.
Related Posts:

Implicit Conversion Fail May 31, 2019...

2019-12-20

639 reads

Blog Post

When Too Much is Not a Good Thing

Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way...

2020-01-06 (first published: )

562 reads

Blog Post

Who needs data access? Not You!

With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:

When Too Much is Not a Good Thing December 13,...

2019-12-30 (first published: )

437 reads

Blogs

The CDO’s Playbook for AI Driven Decision Making

By

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

By

Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...

SELECT *

By

SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...

Read the latest Blogs

Forums

Recursive Select - What is this really doing

By Leo.Miller

I've noticed several instances of what looks like a recursive insert with the format:...

Cleaning Up the Cloud

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cleaning Up the Cloud

The Maximum Value in the Identity Column

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Maximum Value in the...

Visit the forum

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-06
I 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