Mavericks don't make it
One of the blogs I most enjoy reading is Life Beyond Code.
This blog allows me to take off my technology...
2006-02-18
1,435 reads
One of the blogs I most enjoy reading is Life Beyond Code.
This blog allows me to take off my technology...
2006-02-18
1,435 reads
In the tradition of many others, I decided to add a reading list to my professional site. The reading list...
2006-02-16
1,417 reads
I've been out of pocket and off the forums for the last few weeks as
we've had several major tasks where...
2006-02-15
1,365 reads
I saw this on Greg Hughes' blog
and wondered, "What in the world?" So I took a look. It's one of...
2006-02-10
1,423 reads
I've been thinking about doing this for a whole and I finally got
around to building a reviews section into the...
2006-02-08
1,465 reads
2006-01-30
1,070 reads
This is just neat. I saw the link in a post on Tess Ferrandez's blog.
She's an escalation engineer with Microsoft...
2006-01-27
1,518 reads
Atadore has opened up forums for support and feature requests of its
PromptSQL tool. You can find them on the PromptSQL...
2006-01-26
1,352 reads
In reading Gianpaolo Carraro's blog I came across this entry: The architect greatest trick?!
In it he's talking about having seen...
2006-01-26
1,541 reads
I had the opportunity recently to take a look at PromptSQL and offer a
review on it. That review hit SSC.com's...
2006-01-18
1,431 reads
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Comments posted to this topic are about the item Cleaning Up the Cloud
Comments posted to this topic are about the item The Maximum Value in the...
Comments posted to this topic are about the item Oracle Performance Tuning: Practical Techniques...
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 OFFI now run this code.
DBCC CHECKIDENT(TravelLog) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-10-14', '2025-10-17') GOWhat is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025? See possible answers