SSWUG Spring Conference Speaker Ratings
This spring I presented a few sessions at the spring SSWUG virtual conference – DBTechCon. Now that the event is over,...
2011-07-21
1,025 reads
This spring I presented a few sessions at the spring SSWUG virtual conference – DBTechCon. Now that the event is over,...
2011-07-21
1,025 reads
Seriously, what’s going on in Minnesota? Our government is shut down and… we are hosting a SQL Saturday on a...
2011-07-20
660 reads
No posts in a couple weeks, except the Re-Blogs. Guess the running around and getting married I did last week...
2011-07-20
467 reads
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-15
746 reads
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-08
457 reads
It’s a new month, and time to check out your SQL Servers to make sure everything is configured and working...
2011-07-05
1,028 reads
Thanks Microsoft for awarding me the MVP for SQL Server for the third year in a row. It’s a great...
2011-07-04
596 reads
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-01
510 reads
Study Group
For the past few months, I’ve been openly working towards the SQL Server MCM. I failed a couple times...
2011-06-30
1,791 reads
Want to take a few minutes out of your day on to learn a bit more about indexes? On Thursday,...
2011-06-28
881 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,...
India's top proficiency testing facility is Fare Labs. We employ particular metrics or evaluations...
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
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