Physical Join Operators by Ami Levin
For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these...
2013-11-06
668 reads
Kenneth Fisher
Adding a column to a table with a default (NULL vs NOT NULL)
There are lots of ways to learn new things, or be reminded of old things. One of my favorites is...
2013-11-05 (first published: 2013-10-30)
5,142 reads
A look at comments
Everyone knows that we should include comments in our code right? On the other hand the vast majority of us...
2013-10-29 (first published: 2013-10-21)
1,733 reads
Change in SQL 2012 SSMS grid output behavior
It’s one of those things that always aggravated me but not really enough to complain about. When you run a...
2013-10-28
691 reads
Unexpected truncation in FETCH
Yes I’m talking about FETCH as in a cursor, yes everyone hates cursors. But you know cursors are like anything...
2013-10-23
713 reads
I’ve refreshed a test database from prod but now the users can’t access it.
This happens to me all the time. I get a request from a developer to overwrite the test copy of...
2013-10-16 (first published: 2013-10-09)
2,661 reads
Query to compare indexes between two tables
We have a set of databases at my office that use the load and swap method of loading data with...
2013-10-16
1,201 reads
Why you should know how to script as well as use the GUI
Personally I’ve always enjoyed learning the T-SQL for any given task. The GUI is usually pretty easy to figure out...
2013-10-14
1,006 reads
Use TOP instead of SET ROWCOUNT
Both TOP and SET ROWCOUNT are both valid methods of limiting the result sets from a query. They are however...
2013-10-10 (first published: 2013-10-07)
3,969 reads
T-SQL Tuesday #47: Your Best SQL Server SWAG
It’s time for T-SQL Tuesday again and this time Kendal Van Dyke is asking for Your Best SQL Server SWAG....
2013-10-08
744 reads
Blogs
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,...
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
Forums
Don't Forget About Financial Skills
Comments posted to this topic are about the item Don't Forget About Financial Skills
Building a Simple SQL/AI Environment
Comments posted to this topic are about the item Building a Simple SQL/AI Environment
Checking Identities
Comments posted to this topic are about the item Checking Identities
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