a simple joint that makes you think twice
I was reading Two Minute SQL Server Stumpers a few weeks ago and this qustion still sticks in my head. ...
2009-12-01
574 reads
Blog Posts
Baton Rouge SQL Server User Group - Overview of Business Intelligence
Topic
An Overview of Business Intelligence
Location: At Lamar Advertising
Wednesday, December 2, 2009
6:00 PM - 8:00 PM
Sponsored by: EMCPresenter
Brandon McMillon
Brandon McMillon...
2009-12-01
560 reads
BIDN.com Launch Today
For those interested in the SQL Server BI space, there is a new online resource launching today. Brian Knight and...
2009-12-01
1,058 reads
Congratulations to Christopher Graham for Taking Companies to Task About Protecting Data Privacy
The New Information Commissioner for the United Kingdom is Mr. Christopher Graham, he's working from Wilmslow, near Manchester, with a...
2009-12-01
1,344 reads
December 2009 – Baton Rouge SQL Server User Group
December SQL Server User Group Meeting
Location: At Lamar Advertising
Wednesday, December 2, 2009
6:00 PM - 8:00 PM
Sponsored by: EMCTopic
An Overview of...
2009-12-01
495 reads
Google Dashboard
Recently announced, Google Dashboard shows some but not quite all of the data that Google has accrued about you – a...
2009-12-01
1,122 reads
How do -You- use SQL Server
I’ve been tagged by a misplaced yankee, uh, New Englander, whatever. The question is, how do I/we use SQL Server...
2009-12-01
771 reads
Linear Gauge Control: A Practical Use
SQL Server Reporting Services 2008 introduced several new features. One key feature was the inclusion of the Gauge Controls. I...
2009-12-01
7,767 reads
MDX Utility Belt of Calculations Part 1
Developing MDX calculations is one of the most confusing and time consuming pieces of building an Analysis Services cube. That...
2009-12-01
2,687 reads
MDX Utility Belt of Calculations Part 2
This post is a part of a series of blog posts I am writing to give you a Batman-like Utility...
2009-12-01
1,766 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
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...
Show/Hide number of rows in table
We have a report that has multiple tables that list the top 15 performers...
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