Blog Round-up – What Are You Thankful For?
Last week I suggested to others that we institute a little idea theft and put together a few blog posts...
2010-11-29
2,195 reads
Last week I suggested to others that we institute a little idea theft and put together a few blog posts...
2010-11-29
2,195 reads
Protect Your Password! As a consultant, I am frequently receiving new passwords at clients and becoming aware of the password...
2010-11-26
673 reads
Earlier this week, I suggested that we share a message of thanks on our blogs. Since I suggested we put...
2010-11-26
964 reads
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Learning XQuery...
2010-11-24
1,599 reads
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2010-11-23
2,130 reads
Two things happened to me this morning. First, I woke up and took the written test for the SQL Server...
2010-11-22
755 reads
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2010-11-22
2,023 reads
Since it’s Sunday (almost Monday), I thought I would chip into Un-SQL Friday. Before I get down to brass tacks,...
2010-11-22
1,041 reads
About this time last year, Digineer had an internal event where we could share messages of thanks. These messages were...
2010-11-21
581 reads
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2010-11-21
1,253 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