Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-24 (first published: 2019-09-17)
1,004 reads
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-17
2 reads
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-17
12 reads
Tomorrow I get to chat with another giant in the world of DevOps: Jez Humble. I actually met Jez years ago at a conference, and I was honored to...
2019-09-17
16 reads
I am a SQL Administrator and today I will share my experience about an issue on SQL server, which corrupted the transaction logs and left the database in a...
2019-09-25 (first published: 2019-09-17)
2,956 reads
Good morning! It was a tough weekend as we supposed to be in Goteborg on #SQLSatGothenburg but unfortunatelly the flu hit us hard. The talk was handed over by...
2019-09-17
7 reads
Good morning! It was a tough weekend as we supposed to be in Goteborg on #SQLSatGothenburg but unfortunatelly the flu hit us hard. The talk was handed over by...
2019-09-17
26 reads
I’ve found myself traveling quite a bit this year, with more travel on the horizon. Like many, I travel with a fair bit of technology and of course that...
2019-09-17
5 reads
Not something you’ll do too often, but you might find yourself doing this if you are setting up PoCs and removing them. A reminder for me, since I stumbled...
2019-09-16
78 reads
With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used for many of them, a common question I am asked about is “How can I...
2019-09-16
567 reads
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers