PASS, anyone?
In less than two days I'll be in Seattle for my 6th PASS Summit. I am trying to put all the...
2008-11-14
458 reads
In less than two days I'll be in Seattle for my 6th PASS Summit. I am trying to put all the...
2008-11-14
458 reads
MVP Kathi Kellenberger covers the basics of using T-SQL to modify data in your databases.
2008-09-30
3,708 reads
Learn how to summarize the values of your data using aggregate functions such as COUNT(), SUM(), and AVG() from MVP Kathi Kellenberger. Grouping and aggregate filters are covered as well.
2008-08-28
4,929 reads
Andy Warren made a trip to St. Louis this past weekend to put on a speaker workshop for our user...
2008-08-19
1,318 reads
There are many technical conferences available for SQL Server professionals, such as PASS. I have been lucky enough to go...
2008-08-10
1,032 reads
Probably the least enjoyable thing about being a DBA is patching servers. We received the bad news in the July MS...
2008-07-19
1,905 reads
Today is day one of the SSWUG SQL Server Virtual Conference II. This has been really fun so far. Our...
2008-06-24
1,512 reads
Check out the SSWUG Virtual Conference next week. Here is a link with more information: http://www.vconferenceonline.com/sswug/demo.asp . The first 200 people...
2008-06-19
1,575 reads
I gave a presentation Tuesday to my local SQL user group on 2008 T-SQL and data types. One of the items...
2008-06-13
759 reads
I have been thinking about getting the MCT credential for about five years. During the MVP Summit I attended a...
2008-05-30
1,301 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