This Month… SSWUG Free SSIS Expo
Stinking Feet?
A couple months back I mentioned the SSWUG Free Expo Event: Basic and Complex SSIS Features. The time has...
2011-02-01
417 reads
Stinking Feet?
A couple months back I mentioned the SSWUG Free Expo Event: Basic and Complex SSIS Features. The time has...
2011-02-01
417 reads
In case you missed it last week, PASS has announced the speaker lineup for the next 24 Hours of PASS. ...
2011-02-01
551 reads
31 Days of SSIS
We’re at the thirty-first, and last, post for the 31 Days of SSIS. The series started with...
2011-02-01
1,432 reads
Last week I spoke at the PASSMN meeting here in Minnesota and then via a webcast to the Edmonton PASS...
2011-01-31
1,369 reads
31 Days of SSIS
Almost time to wrap up the 31 Days of SSIS. We are down to just two more...
2011-01-31
2,851 reads
31 Days of SSIS
A day late for the twenty-ninth post of the 31 Days of SSIS, but it is still...
2011-01-30
2,373 reads
31 Days of SSIS
It’s Friday and I’m still taking Friday’s off in my 31 Days of SSIS blog series. As...
2011-01-28
881 reads
31 Days of SSIS
Welcome to day twenty-seventh post of the 31 Days of SSIS. We’re getting near the end now. ...
2011-01-28
1,534 reads
Welcome to day twenty-sixth post of the 31 Days of SSIS. We’re getting near the end now. If you have...
2011-01-27
899 reads
Will you be in Edmonton today? How about near a computer connected to the inter-tubes? If so, you might be...
2011-01-26
781 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,...
I've noticed several instances of what looks like a recursive insert with the format:...
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...
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