What do client diagnostics in Cosmos DB mean?
This topic keeps coming up with my customers so the purpose of this blog post is to keep all the useful information in one post. Think of this post...
2024-10-23 (first published: 2024-10-09)
149 reads
Cosmos DB – Monitoring performance
Cosmos DB has become my latest focus and I hope to start sharing more about ways you can use it. Cosmos DB doesn’t provide the same granularity of query...
2023-11-29 (first published: 2023-11-15)
233 reads
Presentation 5: Presenting Performance Tuning with Memory Grants
So it’s about a week after SQL Saturday Chicago 2019. The event was amazing, tons of great people and in a great venue. Here’s the details of what happened...
2019-04-15 (first published: 2019-04-01)
600 reads
Writing a presentation 4: Practice and improvement
My presentation so far is really rough. I need to improve a lot before SQL Saturday Chicago! For now, the...
2019-03-20
1,010 reads
SSMS tip: Splitting the same query window
This is a trick I use in SQL Server Management Studio at least once a week.
Today’s scripts will be screenshots...
2019-03-18 (first published: 2019-03-02)
3,183 reads
Writing a presentation 3: Entering the PowerPoint world
This is a series I’m writing as I prepare for SQL Saturday Chicago 2019. My session is called Performance tuning...
2019-03-18
311 reads
One week blogging hiatus
I’m taking a brief break from daily blogging, even though it has been a ton of fun.
No excuses
I hope...
2019-03-11
221 reads
Optimize for ad hoc VS sp_executesql?
Happy Friday! We made it. Here’s something I came across while testing optimize for ad hoc for this week’s blog...
2019-03-11 (first published: 2019-02-22)
2,126 reads
Favorite community scripts and their parameters
Here’s some of my favorite community scripts and how I like to run them. If you haven’t tried the optional...
2019-03-09
655 reads
Writing my presentation 2: Designing the presentation
This series is about my process for writing my upcoming presentation at SQL Saturday Chicago #825.
Today’s goals
Today I’m going to...
2019-03-08
341 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
Arc Enabled SQL Server
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
Recursive Select - What is this really doing
I've noticed several instances of what looks like a recursive insert with the format:...
Cleaning Up the Cloud
Comments posted to this topic are about the item Cleaning Up the Cloud
Question of the Day
The Maximum Value in the Identity Column
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 OFF
I now run this code.
DBCC CHECKIDENT(TravelLog)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-10-14', '2025-10-17')
GO
What is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025?
See possible answers