SQL Server 2014 SP1 released, and revoked
Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has...
2015-04-16
629 reads
Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has...
2015-04-16
629 reads
Sean’s RegEx for DBAs class must be finally sinking in for me. Today I was able to figure out a...
2015-04-07
506 reads
Today I learned that you can’t adjust the font size in SQL Server Management Studio’s Object Explorer pane. Nor registered...
2015-04-02
612 reads
I’ve talked about NULLs before. (Ref: Here’s a bit on ISNULL(), and here’s one about understanding NULL at a basic level.)...
2015-03-16
576 reads
We’re in London right now for SQLBits, which has been ABSOLUTELY LOVELY so far. If you happen to’ve seen our...
2015-03-06
440 reads
We were having a good time on DBAs@Midnight, when Sean got a weird pop up message that said all his...
2015-02-07
1,114 reads
We released Minion Reindex version 1.1 last week. The changes are fairly small: Made sure Minion Reindex handles all nonstandard naming...
2015-01-29
1,252 reads
Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to...
2015-01-23
1,929 reads
It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes...
2014-12-15
643 reads
I’m reading Andy Warren’s excellent essay “Thoughts on raising funds and spending funds for PASS chapters”, and it’s bringing together...
2014-11-13
862 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