Saying Goodbye To 2009
I'll close out 2009 with an update on the goals I set at the beginning of this year and things...
2009-12-31
1,392 reads
Blog Posts
Script Individual User Rights in a Database with PowerShell
Introduction
Tonight on Twitter the call went out on #SqlHelp looking for a way to script just database permissions for a...
2009-12-31
1,424 reads
Stored Procedures to Store and Get Database Users with All Permissions
Introduction
Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the...
2009-12-31
1,766 reads
A Small Collection of I/O Specific DMV Queries
It is pretty common for large, busy SQL Server implementations to run into I/O pressure or bottlenecks, especially since many...
2009-12-30
4,222 reads
Looking back at 2009 Goals
I set goals at the start of 2009 for the year. They were:
Continue with 400 posts a month Blog Daily...
2009-12-30
1,727 reads
Practice Your Restores
Steven Jones posted an excellent editorial today all about how your backups are only good if you know that you...
2009-12-30
1,319 reads
Running a Small User Group - The Tools
Because running a small user group is a labor of love, we look for time savings wherever we can to...
2009-12-30
1,826 reads
Wrapping Up Blogging for 2009
I think I’ve met my goal of blogging every day. I’m at almost 800 posts now over the past 2.5...
2009-12-30
1,398 reads
Analysis Services Performance Optimization Tips
Over the last few weeks I have focused most of my blog energy into writing a couple articles. So I...
2009-12-29
1,868 reads
Running a Small User Group - Getting Help
When we first started Midlands PASS, we tried to do it the way PASS suggested. We tried to get folks...
2009-12-29
1,413 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