Knowing What's Normal
This week Database Weekly has a lot of performance related posts and Steve Jones notes that those are not of much use unless you know you really do have a performance problem.
2010-06-07
151 reads
Editorial
What Will We Take For Granted Tomorrow?
A guest editorial from Tim Mitchell today looks at technology, and how quickly we become accustomed to it.
2010-06-07
118 reads
Limited Features or Limited Time?
A guest editorial today from Andy Warren. When someone is looking to introduce a free version of a product, what's the best way to tackle it?
2010-06-04
141 reads
Change the Edition or Change the Design?
Today Steve Jones talks about revisiting your design and perhaps thinking about buying another edition of SQL Server to take advantage of some feature.
2010-06-03
119 reads
Loud
Working in an office was quite a change for Steve Jones recently. He comments today that it might be something you need to consider when hiring others as well.
2010-06-02
167 reads
TCA
SQL Server has a lower TCA, total cost of administration, than Oracle. Steve Jones comments today on a few of the reasons.
2010-06-01
128 reads
Getting the Message
Regardless of the speed of your SQL routines there comes a time, for any server-based system, when you need to think "parallel" and "asynchronous". So why, Phil Factor wonders, does there seem to be so little interest in Service Broker?
2010-05-31
240 reads
2010-05-31
56 reads
Would You Do Your Hobby for a Living
Today we have a guest editorial from Andy Warren that asks about your hobbies, and would you trade your job for one of them?
2010-05-28
151 reads
Personal Privacy
A new technique to help anonymize medical research data has been developed, and could help with other types of data, but there is an issue.
2010-05-27
85 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