31 Days of SSIS – Using Breakpoints (2/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Today’s post is going...
2011-01-02
562 reads
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Today’s post is going...
2011-01-02
562 reads
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Let’s start off this series with a...
2011-01-01
12,383 reads
31 Days of SSIS
Last year, Glenn Berry (Blog | @GlennAlanBerry) wrote a series of posts that he called A DMV A...
2011-01-01
2,296 reads
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Within the...
2010-12-31
1,757 reads
She can dig it!
D Sharon PruittWe’re up to the seventh post on the in the plan cache series. This time...
2010-12-30
1,966 reads
If you are in Minnesota and are looking for a new job, Digineer is hiring. Heck you can even be...
2010-12-29
596 reads
Goal Setting
It’s time to wrap up the year. I don’t have a resolutions or goals post from last year to...
2010-12-28
899 reads
She can dig it!
D Sharon PruittA few posts ago in the plan cache series I discussed the children for the...
2010-12-28
1,197 reads
Watching videos?! Su-ure!
Time for the third week of blogging about the things that I’m doing to study for the MCM...
2010-12-27
548 reads
She can dig it!
D Sharon PruittA couple posts ago in the plan cache series I discussed the children for the...
2010-12-22
907 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