Make BOL your friend
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work...
2014-06-30
4,013 reads
Kenneth Fisher
Dealing with a long string
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...
2014-06-25
2,461 reads
sp_SrvPermissions & sp_DBPermissions V5.0
These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures...
2014-06-23
687 reads
Aliasing a SQL Server: When it works, when it doesn’t and when it may be your problem.
Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager...
2014-06-20 (first published: 2014-06-18)
2,333 reads
I don’t want to grant permission to all the tables in the database at once.
A couple of weeks ago I did a post on granting or denying permissions to all the tables within a...
2014-06-16
1,162 reads
What is this default trace you speak of?
I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge...
2014-06-12
838 reads
MJ Swart offers free technical editing
A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me...
2014-06-09
884 reads
Who has the DAC open?
The other day I started seeing the following error in my SQL log.
Error: 17810, Severity: 20, State: 2.
Could not connect...
2014-06-05 (first published: 2014-05-28)
2,565 reads
15 years of experience with Identity columns
An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...
2014-06-04
1,047 reads
What is the difference between Money and Decimal(19,4)
One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4)....
2014-06-02
1,914 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