The Next Phase of My Career
For anyone who hasn't seen an update somewhere else in the social media universe, I recently started a new job...
2013-11-18
615 reads
Nebraska SQL from @DBA_ANDY
Hung SQL Server Restores from Tivoli Storage Manager/Tivoli Data Protection
I ran into this with a client last night when trying to restore their SQL Server data warehouse database from...
2013-07-10
2,463 reads
New Page - "How to Get Involved With the SQL Server Community"
I recently composed an email (on the side) for a client DBA looking for info on getting involved with the...
2013-06-19
507 reads
SQLPerformance.com
I have had the opportunity to go through the first three SQLSkills Immersion Events, and one of the side benefits...
2013-05-28
606 reads
T-SQL Tuesday #42 - The Long and Winding Road
It's T-SQL Tuesday again (Thanks go to Adam Machanic (B/T)) and this month the host is Wendy Pastrick (B/T). Wendy's...
2013-05-14
661 reads
Announcing SQL Saturday 197 Omaha Pre-Cons!
Here is a flyer produced by someone on the team - he says it all very well:
--
Friday, April 5, 2013
Get Warmed...
2013-02-07
799 reads
The Value of Certifications
A former co-worker recently sent me an email asking about Microsoft certifications, and if I pursued them, and what I...
2013-02-05
1,090 reads
Why is My New Server Under CPU Pressure?
Signal waits frequently translate to the amount of time that SQLOS is under pressure for CPU resources, as outlined in...
2013-01-28 (first published: 2013-01-24)
2,920 reads
Everybody Needs to Know About Recovery
My friend and SQL Server professional Tim Radney (blog/@tradney) has written a new entry in the Joes2Pros series:
You can get...
2012-11-01
754 reads
A Minor Problem of Access
A colleague sent this - they received a trouble ticket where a user who had "all access" to the database couldn't...
2012-10-19
627 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
Arc Enabled SQL Server
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
Recursive Select - What is this really doing
I've noticed several instances of what looks like a recursive insert with the format:...
Cleaning Up the Cloud
Comments posted to this topic are about the item Cleaning Up the Cloud
Question of the Day
The Maximum Value in the Identity Column
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')
I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON
INSERT dbo.TravelLog
(
TravelLogID,
CityID,
StartDate,
EndDate
)
VALUES
(25, 5, '2025-09-12', '2025-09-17')
SET IDENTITY_INSERT dbo.TravelLog OFF
I now run this code.
DBCC CHECKIDENT(TravelLog)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-10-14', '2025-10-17')
GO
What is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025?
See possible answers