SQL Saturday #91
This weekend I attended my 5th SQL Saturday, SQL Saturday #91 in Omaha. Every SQL Saturday I have attended has...
2011-08-28
1,199 reads
This weekend I attended my 5th SQL Saturday, SQL Saturday #91 in Omaha. Every SQL Saturday I have attended has...
2011-08-28
1,199 reads
In case you hadn't noticed, PASS has a number of virtual chapters. Many of the virtual chapters broadcast LiveMeetings about once...
2011-03-20
1,119 reads
This past weekend I attended another SQL Saturday. This one was held in Louisville, KY. Malathi Mahadevan and her volunteers...
2011-01-23
1,346 reads
Last year I was honored to be a member of the Women in Technology (WIT) Panel at the PASS Summit....
2010-11-17
1,192 reads
There is always a lot of talk about the fact that we have been in Seattle several years in a...
2010-11-16
1,148 reads
PASS Summit 2010 is now history. This is my eighth summit but the first one since leaving the DBA world...
2010-11-15
1,548 reads
This past Saturday, I spent the day at SQL Saturday #49 in sunny Orlando. Since Orlando is way out of...
2010-10-18
1,096 reads
The KC PASS chapter has successfully executed the latest SQL Saturday. Thanks to all the organizers and volunteers for a...
2010-10-03
1,993 reads
I attended my first SQLSaturday yesterday in Iowa City, Iowa. I spoke on two topics: “What’s New with Reporting Services”...
2010-09-19
1,611 reads
Can you believe that I have never attended a SQLSaturday (http://www.sqlsaturday.com)? Well, that is changing very soon. You will see me at...
2010-09-08
832 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