PASS Summit 2018 – Day 1 – 11/7/2018
I am proud and fortunate to be sitting beside stars of the community at the blogging table this year. I...
2018-11-07
229 reads
Mala Mahadevan
T-SQL Tuesday 108 Invitation- Non SQL Server Technologies
I am proud and honored to be hosting T-SQL Tuesday again. This monthly blog party started by SQL Guru Adam...
2018-10-29
317 reads
Protected: TSQL Tuesday 108 – Community Rituals
This post is password protected. You must visit the website and enter the password to continue reading.
Advertisements
2018-10-25
223 reads
Data Professionals at Work – a book-writing adventure
I love to write. It is how I express myself best. During the last fall I was pondering starting on...
2018-09-04
261 reads
10 SQL Saturdays – and a personal parting of ways
I’ve written many posts on SQL Saturdays , especially the one at Louisville. This one is a bit different. This is...
2018-07-23
222 reads
Lessons on relocating – from running SQL Saturdays
I recently accepted a job offer in another town and relocated from my base of Louisville, KY. I have not...
2018-06-04
255 reads
Ohhhhhh S…t!! A tribute to Robert Davis
Today marks 3 days since we’ve lost Robert Davis a.k.a SQLSoldier, one of the pillars of SQL Family community.
I was...
2018-04-13 (first published: 2018-04-05)
3,113 reads
Data experiments with salary survey – I
As someone who just crossed three decades of working in technology – I have a sudden renewed interest in understanding how...
2018-03-22 (first published: 2018-03-12)
2,727 reads
My experience with TechOutbound 2018 – Caribbean
I am a passionate, regular attendee of Techoutbound (formerly SQLCruise) events. I try to do at least one every year. ...
2018-02-26
372 reads
DBA best practices..from the DBA from Heaven
I met Tom Roush for the first time around 9 years ago – at a PASS Summit. If I recall right...
2018-02-01
689 reads
Blogs
Advice I Like: Fear and Imagination
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
Cloud Data Driven User Group 2025 – Slides & Scripts
The slidedeck and the SQL scripts for the session Indexing for Dummies can be...
Leading Through Change: Guiding Teams in Times of Uncertainty
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
Forums
Simple delete causes table scan on other tables with foreign key
Why is sql doing a full scan VS seeking on the index? I've included...
Show/Hide number of rows in table
We have a report that has multiple tables that list the top 15 performers...
Replication from IBMi DB2 to MS SQL
We have a tool called DB Moto that reads journals (like t-logs) and replicates...
Question of the Day
Checking Identities
The DBCC CHECKIDENT command is used when working with identity values. I have a table with 10 rows in it that looks like this:
TravelLogID CityID StartDate EndDate 1 1 2025-01-11 2025-01-16 2 2 2025-01-11 2025-01-16 3 3 2025-01-11 2025-01-16 4 4 2025-01-11 2025-01-16 5 5 2025-01-11 2025-01-16 6 6 2025-01-11 2025-01-16 7 7 2025-01-11 2025-01-16 8 8 2025-01-11 2025-01-16 9 9 2025-01-11 2025-01-16 10 10 2025-01-11 2025-01-16The docs for DBCC CHECKIDENT say this if I run with only the table parameter: "If the current identity value for a table is less than the maximum identity value stored in the identity column, it is reset using the maximum value in the identity column. " I run this code:
DELETE dbo.TravelLog WHERE TravelLogID >= 9
GO
DBCC CHECKIDENT(TravelLog, RESEED)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-09-14', '2025-09-17')
GO
What is the identity value for the new row inserted by the insert statement above? See possible answers