Article of the Week – Kimberly L. Tripp (Partitioned Tables and Indexes)
When partitioning was first introduced in SQL Server 2005, I thought what a great idea. However, when I started reading...
2009-11-16
2,661 reads
Blog Posts
Blowing Off Steam and Recharging
I’ve written a few things about why conferences and events are good, or why it’s valuable for an IT worker...
2009-11-16
712 reads
Fighting the Flu
Last Monday was my first day back from the PASS Summit, planned for (and was) a slow day, just starting...
2009-11-16
493 reads
Today’s SQL Lunch – Integrating Table Valued Parameters with Reporting Services 2008
Meeting URL: Join Meeting
Click the above Meeting URL around 11:30 AM CST on 11/16/2009 to join the meeting
Date: 11/16/2009
Time: 11:30...
2009-11-16
1,262 reads
Why does change control for SQL Server have to be so hard?
I’ve been dealing with change control and source code repositories for most of my professional career. While I’ve seen change...
2009-11-16
1,435 reads
Hot Sauce Links
New friend David Easley shared two sources for hot sauce that I wasn’t familiar with:
http://www.datilsensation.com/products.shtmlhttp://www.pepperpalace.com/I like some spice here and...
2009-11-15
524 reads
Marketing Mistakes and Poor Customer Service can Hurt Your Business
Yesterday, I was able to cause a potential customer to buy a competing product. In fact, according to my tally...
2009-11-15
393 reads
Using Dedicated NICs to Segregate SQL Server 2008 Backup Traffic
If you need to initialize a mirrored database for SQL Server 2008 Database Mirroring, one of the first things you...
2009-11-14
1,434 reads
Indentifying Performance Bottlenecks presentation
Thanks to everyone who attended the State of Tennessee’s .NET User Group meeting yesterday. I really enjoyed spending time with...
2009-11-13
828 reads
Looking Back – PASS Summit 2009 Day 5
Since this was my time visiting Seattle I opted to stay an extra day and take in the sights and...
2009-11-13
588 reads
Blogs
Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings
SQL Server 2025 introduces native support for vector data types and external AI models....
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...
Forums
How to use data pre-computed in previous ETL SSIS Nodes?
I'm building ETL packages in SSIS. My data comes from an OLE DB Source...
Building AI Governance and Policies- First Steps
Comments posted to this topic are about the item Building AI Governance and Policies-...
Simple delete causes table scan on other tables with foreign key
Why is sql doing a full scan VS seeking on the index? I've included...
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