31 Days of SSIS – Create XML Document (13/31)
31 Days of SSIS
Day thirteen and we are trucking along with the 31 Days of SSIS blog series. The last...
2011-01-13
1,942 reads
31 Days of SSIS
Day thirteen and we are trucking along with the 31 Days of SSIS blog series. The last...
2011-01-13
1,942 reads
31 Days of SSIS
This is the twelfth post in the 31 Days of SSIS blog series. This post is going...
2011-01-12
992 reads
31 Days of SSIS
The last post discussed the Pivot transformation – that leads us to this post which will be on...
2011-01-11
1,148 reads
Time for the first T-SQL Tuesday of 2011. This month Jen McCown (Blog | @midnightdba) is hosting the event. The topic...
2011-01-11
559 reads
Watching videos?! Su-ure!
Week five and it seems like time is going by faster than I had expected it would. As...
2011-01-11
279 reads
A few months back, well before the 31 Days of SSIS started, I had been playing with the Pivot Transformation. ...
2011-01-10
1,172 reads
Before the year gets going too far and things are too planned out, I thought I would see if there...
2011-01-10
409 reads
Day number 9 of the 31 Days of SSIS. If you missed the first week then start by reading the...
2011-01-09
1,032 reads
31 Days of SSIS
Welcome to day eight post for the 31 Days of SSIS. If you are just joining the...
2011-01-09
828 reads
If you are up in Edmonton around January 26th, you can hear my voice at the EDMPASS January user group...
2011-01-07
424 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