I'm presenting at 24 Hours of Pass!!
Woohoo! I have been selected to present my SSIS Tips & Tricks presentation at this year's 24 Hours of Pass. I am...
2012-03-04
505 reads
Woohoo! I have been selected to present my SSIS Tips & Tricks presentation at this year's 24 Hours of Pass. I am...
2012-03-04
505 reads
I'll be giving a presentation tomorrow, Tuesday 2/21/2012 at 12PM EST on my Enhanced Threading Framework design. Here is the...
2012-02-21
407 reads
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks"...
2012-02-21
1,340 reads
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations. I had to build one moments ago and...
2012-02-21
7 reads
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations. I had to build one moments ago and...
2012-02-21
4 reads
I built a small ruby program a while back to help with two things:
Quickly identify what tables have the highest...
2012-02-16
567 reads
I built a small ruby program a while back to help with two things:
1. Quickly identify what tables have the highest IO in a particular
...
2012-02-16
3 reads
I built a small ruby program a while back to help with two things:
Quickly identify what tables have the highest IO in a particular query
Learn a new language (Ruby)
The...
2012-02-16
2 reads
The other day I was building a simple data import package when I ran into a common situation; invalid conversions...
2012-02-01
729 reads
The other day I was building a simple data import package when I ran into a
common situation; invalid conversions in a Derived Column. The conversion
was taking an ISBN13...
2012-02-01
15 reads
The slidedeck and the SQL scripts for the session Indexing for Dummies can be...
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Comments posted to this topic are about the item Don't Forget About Financial Skills
Comments posted to this topic are about the item Building a Simple SQL/AI Environment
Comments posted to this topic are about the item 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') GOWhat is the identity value for the new row inserted by the insert statement above? See possible answers