Video Featured on SQLShare
I didn’t have a chance to blog this yesterday (January 11, 2010), but my most recent video, Dynamic SQL Using...
2010-01-12
475 reads
Blog Posts
We Interrupt Your Regular SQL Blogging For This Announcement…
EXEC sys.sp_addextendedproperty
@name = N'IsWifePregnant',
@value = N'True',
@level0type = N'USER',
@level0name = N'Kendal.VanDyke' ;
EXEC sys.sp_addextendedproperty
@name = N'ExpectedDueDate',
@value = N'August 2010',
@level0type = N'USER',
@level0name...
2010-01-12
793 reads
Webcast Tomorrow - Dynamic SSIS: Using Expressions and Configurations
Join me tomorrow at 1:00pm CST as I present "Dynamic SSIS: Using Expressions and Configurations" for the PASS DBA virtual...
2010-01-12
1,021 reads
Would Third-party Product Driven/Vendor Sessions Benefit User Groups and Community Events?
In the the couple of years I have been involved in the SQL Server community I have noticed that there...
2010-01-12
783 reads
A Time and a Place for the SQL Server Maintenance Plan Wizard
Reprinted from my editorial in Database Weekly.
In the course of my job, I get to give a lot of presentations,...
2010-01-11
363 reads
Horror… sort of
You must read this post from Tim Ford to understand why I might do this on my technical blog. But...
2010-01-11
878 reads
Kevin Cox from SQLCAT Presenting at the Denver SQL Server User’s Group On January 21, 2010
Kevin Cox, who is part of the SQLCAT Team at Microsoft, will be giving the presentation at this month’s Denver...
2010-01-11
815 reads
Lock configuration setting and preventing locking contention
The locks configuration option for SQL Server controls the number of locks available in SQL Server. You can view this...
2010-01-11
719 reads
More Laptop Issues
My laptop died on Dec 1, 2009. I was on vacation, but on Dec 2 I called Toshiba (I have...
2010-01-11
1,066 reads
New England Data Camp v2/SQL Saturdy #34 Update
The second annual New England Data Camp is shaping up to one excellent event. We’ve put together a great set...
2010-01-11
546 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