Relational By Default
Should we consider the relational model the default and only after having a good reason look at a NoSQL platform? Steve Jones has a few comments.
2015-11-18
103 reads
Editorial
Private Data
The laws and morals regarding privacy aren't well defined, but Microsoft is making a stand.
2015-11-17
109 reads
Rogue Software Changes
Today Steve Jones wonders if software developers would make changes to software on their own, without direction from management.
2019-10-29 (first published: 2015-11-16)
305 reads
Mind your Database Ps and Qs
Louis Davidson explains why a little database courtesy goes a long way.
2015-11-16
223 reads
2019-11-04 (first published: 2015-11-13)
415 reads
2015-11-12
221 reads
Do You Have Scary Code?
Many organizations have code no one wants to touch. Steve Jones notes that's a bad place to be.
2015-11-10
250 reads
2015-11-09
226 reads
A big thank you
Grant Fritchey shows his softer side, extending his appreciation to all DBAs who work tirelessly to keep our software running in the face of adversity.
2015-11-09
690 reads
The Lost Laptop Crisis
Losing a laptop isn't something most of us would want to deal with, usually because of the expense. However, there may be other implications that concern you. Share your worries with us today.
2015-11-06
118 reads
Blogs
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,...
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Forums
Don't Forget About Financial Skills
Comments posted to this topic are about the item Don't Forget About Financial Skills
Building a Simple SQL/AI Environment
Comments posted to this topic are about the item Building a Simple SQL/AI Environment
Checking Identities
Comments posted to this topic are about the item Checking Identities
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