2017-11-29
177 reads
Kenneth Fisher
SQL Puzzle – Word Scrambler
I’ve been writing crosswords for the last few months and to change things up I thought I would do a...
2017-11-29
554 reads
Why shouldn’t I shrink my database data file?
A while back I did a post about why you shouldn’t shrink your data file. This one is going to...
2017-11-20
454 reads
Variables in Dynamic SQL
I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement....
2017-11-16
1,486 reads
2017-11-15
448 reads
It takes a village
Ewald Cress (b/t) is our host this month for Adam Machanic’s (b/t) monthly blog party T-SQL Tuesday. Having just gotten...
2017-11-14
327 reads
SQL Homework Nov 2017: Create a view
Views are a highly useful tool for abstracting how you see the data stored in tables. At their simplest, they...
2017-11-13 (first published: 2017-11-01)
1,507 reads
More Collation Confusion. (tempdb)
I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance...
2017-11-08
395 reads
DBA Definitions: FILLFACTOR
It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing...
2017-11-06
508 reads
When is it a good idea to consolidate multiple instances?
In this age of cost-saving after cost-saving, one way you may be looking at saving money is by combining multiple...
2017-11-01 (first published: 2017-10-23)
2,113 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