Minnesota SQL Server Study Group
Study Time!
A few weeks back, I sent a message on the PASSMN LinkedIn group page about expanding the MCM study...
2011-05-09
680 reads
Study Time!
A few weeks back, I sent a message on the PASSMN LinkedIn group page about expanding the MCM study...
2011-05-09
680 reads
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-05-06
562 reads
SQLRally is a week away. Are you ready? It’s going to be a good time to learn and freshen up...
2011-05-04
478 reads
Earlier today, Thomas LaRock (Blog | @SQLRockstar) tagged me for his Meme Monday post. The question for today is: how many...
2011-05-02
566 reads
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-04-29
1,451 reads
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-04-22
561 reads
I’ve been counting down the days until I get the score from my second attempt at the SQL Server MCM...
2011-04-19
498 reads
I mentioned the April PASSMN meeting the other day… well now that meeting is tomorrow. Take a chance to invest...
2011-04-18
573 reads
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-04-15
568 reads
Over the last couple months, I’ve been trying to figure out what to do with some of my old posts. ...
2011-04-14
446 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