Where in the world are Jen and Sean?
Updated with more SQL Saturdays! Well hi there, folks. A month slips by so very fast. Here is your January...
2016-01-28
1,035 reads
Updated with more SQL Saturdays! Well hi there, folks. A month slips by so very fast. Here is your January...
2016-01-28
1,035 reads
Let’s have some fun with operator precedence today. Specifically, logical operator precedence. Specifically, how is it evaluated when your where clause...
2016-01-06 (first published: 2015-12-31)
2,811 reads
PASS just published an anti-harassment policy reminder, quickly followed by a blog by Wendy Pastrick (about a bad experience at last...
2015-11-25
944 reads
Twice in two days now, I’ve gotten in discussions with people about the state of data usage…the idea that we have...
2015-11-12
696 reads
We released Minion Backup 1.1 and Minion Reindex 1.2 this week! We’ve got a some great new features, and a number of bug fixes....
2015-10-23
664 reads
We’re just two weeks away from the PASS Summit in Seattle, and there is most definitely still time to get...
2015-10-12
607 reads
It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on...
2015-10-07
659 reads
Register here. In our monthly series about Minion Enterprise – the new SQL Server management solution – Sean and Jen will show you how...
2015-10-06
636 reads
This weekend we’re going to hit SQL Saturday San Diego for the first time ever! We are the excited. Come and...
2015-09-18
806 reads
Time for the T-SQL Tuesday #70 roundup! I asked people for their best enterprise management strategies, and they responded beautifully....
2015-09-10
749 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
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...
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
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