This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check...
2020-01-27 (first published: 2020-01-21)
227 reads
When you use delta lake there are a couple of interesting things to note based around the fact that the data is stored in parquet files which are read-only...
2020-01-20
5 reads
When you use delta lake there are a couple of interesting things to note based around the fact that the data is stored in parquet files which are read-only...
2020-01-20
21 reads
I know, I know, I’m on #teamexevents so I think that Extended Events can do no wrong, but let’s address this thought that Profiler is easier. Now, if we’re...
2020-01-28 (first published: 2020-01-20)
533 reads
I am super excited to announce that I have been selected to speak at SQL Saturday Spokane on March 21, 2020. Not only have I been selected to speak,...
2020-01-20
16 reads
I don’t know how many of you are working with Windows Core these days but personally I think it’s a ... Continue reading
2020-01-29 (first published: 2020-01-20)
439 reads
In this video, David give a quick introduction into the Undercover Catalogue.
2020-01-20
42 reads
A few years ago, I wrote about my first experience speaking at SQL Saturday. Recently I had a conversation with one of our first-timers speaking at SQL Saturday Rochester...
2020-01-20
16 reads
FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over 20 years. Second FUN FACT: the last time I took a Microsoft certification exam was...
2020-01-18
8 reads
FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over 20 years. Second FUN FACT: the last time I took a Microsoft certification exam was...
2020-01-24 (first published: 2020-01-18)
1,142 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