Snowflake Warehouses
Everyone has heard of scaling up and scaling out compute. Have you ever heard about a term called scaling across? Before Snowflake, I never. Scaling up and down is...
2022-10-11
17 reads
Everyone has heard of scaling up and scaling out compute. Have you ever heard about a term called scaling across? Before Snowflake, I never. Scaling up and down is...
2022-10-11
17 reads
Recently, a person asked about the costs differences in an execution plan, referencing them as if they were performance measures. The key to understanding performance is to check every...
2022-10-10
6 reads
Today’s coping tip is to write down three things you can look forward to in the next month. Easy. Visiting my daughter. I’m heading up this weekend to watch...
2022-10-10
9 reads
Scary Scalar Functions series overview
Part One: Parallelism
Part Two: Performance
Part Three: The Cure
Part Four: Your Environment
Foreword
In the previous posts, we have learned why Scalar Functions (UDFs) are bad for parallelism...
2022-10-10 (first published: 2022-10-02)
610 reads
You can find the slides and the demo scripts (.sql files) in my Github repo. You can use the materials as you like, attribution would be nice 🙂
The post...
2022-10-10
24 reads
A little while back I came across this post: Identifying failed queries with extended events. It has a script to ... Continue reading
2022-10-10 (first published: 2022-09-27)
332 reads
Today’s coping tip is to be willing to share how you feel and ask for help when needed. This has been something that I never did well. My parents...
2022-10-07
7 reads
Ever since its official launch around October 2021, Microsoft Purview has been one of the more popular services in Azure, with a steady stream of new features expanding the...
2022-10-07 (first published: 2022-09-27)
743 reads
Over the last few years, I’ve had a few people ask me why I don’t create two Twitter accounts so I can separate work and personal things. I choose...
2022-10-07 (first published: 2022-09-26)
220 reads
Today’s coping tip is to remind yourself that you are enough just as you are. This is interesting, as I’m not satisfied with who I am today. I’m not...
2022-10-06
4 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...
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
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:...
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