A Rickety Stairway to SQL Server Data Mining, Part 10.2: DMX DML
by Steve Bolton
The three introductory posts in this series of self-tutorials on SQL Server Data Mining (SSDM) and the...
2013-03-26
2,216 reads
by Steve Bolton
The three introductory posts in this series of self-tutorials on SQL Server Data Mining (SSDM) and the...
2013-03-26
2,216 reads
by Steve Bolton
As users become more familiar with software, they typically follow a progression that begins with learning the...
2013-03-14 (first published: 2013-03-11)
3,121 reads
by Steve Bolton
The data mining method known as Time Series is aptly named, because it seems to take a...
2013-02-26
3,110 reads
by Steve Bolton
In last week’s edition of this amateur series of self-tutorials[i] on SQL Server Data Mining (SSDM), we...
2013-02-21
2,002 reads
by Steve Bolton
In last week’s installment of this amateur series of self-tutorials on SQL Server Data Mining (SSDM), we...
2013-02-19 (first published: 2013-02-12)
3,278 reads
by Steve Bolton
In last week’s installment of this series of self-tutorials on SQL Server Data Mining (SSDM), we covered...
2013-02-07
2,536 reads
by Steve Bolton
Anyone who has been following this series of self-tutorials has probably grown accustomed to me adding some...
2013-01-30
2,941 reads
by Steve Bolton
In the last installment of this series of self-tutorials on SQL Server Data Mining (SSDM), A Rickety...
2013-01-23
2,723 reads
by Steve Bolton
This series of self-tutorials is an elementary-level introduction to SQL Server Data Mining (SSDM), not the product...
2013-01-16
2,933 reads
An algorithm that starts with the word “regression” seems an unlikely candidate to move forward with this series of self-tutorials...
2013-01-08
4,414 reads
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
SQL Server 2025 introduces native support for vector data types and external AI models....
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
I'm building ETL packages in SSIS. My data comes from an OLE DB Source...
Comments posted to this topic are about the item Building AI Governance and Policies-...
Why is sql doing a full scan VS seeking on the index? I've included...
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') GOWhat is the identity value for the new row inserted by the insert statement above? See possible answers