Email: Getting My Attention, The Wrong Way
I was scrolling through my professional email as my wife drove me in to work (my car is being looked...
2009-12-11
650 reads
Blog Posts
Load Windows 7 with a Thumb Drive
With the explosion of Netbooks, it has become important to find new ways to load operating systems. I recently picked...
2009-12-11
313 reads
Locking Scripts
Thanks to everyone who attended my TechNet Thrive! and Nashville SQL Server User Group presentations this week! I hope it...
2009-12-11
407 reads
Orlando Tiki Hut Roadshow Silverlight Edition
Assuming no major problems at work, I’m heading to the South side of town the afternoon of Dec 14, 2009...
2009-12-11
382 reads
Reporting Services Carriage Return
Often when designing a report you may find a need to concatenate values in an expression. For example, you want...
2009-12-11
1,385 reads
Running SSIS 32-bit drivers or tasks on a 64 bit machine
This is an answer to a forum question on www.bidn.com
Running SSIS on a 64-bit machine has several caveat that developers...
2009-12-11
4,742 reads
Running SSIS 32-bit drivers or tasks on a 64 bit machine
Running SSIS on a 64-bit machine has several caveat that developers need to be aware of. Tasks like the ActiveX...
2009-12-11
512 reads
Some SQL Server 2005/2008 Monitoring Stored Procedures
Here is a collection of five stored procedures that are very useful for monitoring the overall health of a SQL...
2009-12-11
1,144 reads
SQL Lunch # 5 – Looping Logic in SSIS
SQL Lunch # 5 – Looping Logic in SSIS
Speaker:Tim Mitchell
Topic:Looping Logic in SSIS
Meeting URL:JOIN MEETING
ADD TO OUTLOOK CALENDAR
Description:
Software developers have long taken...
2009-12-11
995 reads
Using a SSRS Report to run SQL Agent Jobs part 2
In part one of this post I showed how you can use a report to run SQL Server Agent Jobs by...
2009-12-11
1,874 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
Show/Hide number of rows in table
We have a report that has multiple tables that list the top 15 performers...
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
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