More Layers - iPod
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
2008-02-03
37 reads
Articles
More Layers - MP3
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
2008-02-03
38 reads
More Layers - WMV
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
2008-02-03
41 reads
Copyright at SQLServerCentral.com
Just to set the record straight, if you submit something you keep the copyright.
2008-02-01 (first published: 2007-01-30)
1,891 reads
Designing an Entity Data Model
The Entity Framework is an exciting new technology being developed for ADO.NET. It allows developers to view data using a logical model instead of a physical model, offering more flexibility.
2008-02-01
3,492 reads
Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5
Learn how to solve a couple of common T-SQL issues with MVP Jeff Moden.
2008-01-31
17,842 reads
SQL Server 2005: Intro to XQuery
Longtime SQL Server expert Michael Coles brings us the second part of his his introductory look at XML in SQL Server 2005 with a short examination of XQuery, the way in which you can write queries on XML data.
2008-01-31 (first published: 2007-02-20)
22,227 reads
theSystem
This is one in a series of articles dealing with Database Design following the design of a single system from start to finish.
2008-01-31
3,791 reads
The Data Stewardship Approach to Data Governance: Chapter 3
In this article I will settle down a little bit and share with you tools that I have used as part of the data governance trade.
2008-01-31
1,234 reads
2008-01-31
46 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
Replication from IBMi DB2 to MS SQL
We have a tool called DB Moto that reads journals (like t-logs) and replicates...
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
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