No Caps for SQL Saturday : Speaker Edition
A few weeks back, I got into a conversation about whether PASS should put the boot down on events and...
2012-05-17
1,001 reads
A few weeks back, I got into a conversation about whether PASS should put the boot down on events and...
2012-05-17
1,001 reads
This month, Chris Shaw (Blog | @sqlshaw) is leading the charge on the T-SQL Tuesday. This event is basically a blogging...
2012-05-08
996 reads
They say, “April showers bring May flowers.” But what if it doesn’t bring May flowers? What if instead you get...
2012-05-08
834 reads
She Can Dig It!
A while back I was asked, if you can use the plan cache to determine which plans...
2012-05-04
1,436 reads
If you’ve been following this blog for a while, you have probably noticed that the content here has been a...
2012-05-03
709 reads
Ever wanted to hang out and talk about SQL Server over lunch? Maybe get a chance to ask those questions...
2012-05-02
615 reads
Another month goes by and it’s time again to ask… are your SQL Servers healthy? Have they been properly configured? ...
2012-04-12
888 reads
Is SQLCLR good or evil? Thomas LaRock (Blog | @SQLRockstar) is asking that question this month in his #MemeMonday blog party.
Let’s...
2012-04-10
1,131 reads
Before the advent of the modern “Social Network”, many of us were already connected through tools that had much less...
2012-04-09
817 reads
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-30
1,865 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