Yesterday, some new views were made available in the Azure portal that will be helpful to those of us who create or manage Azure SQL resources. First, a new...
2019-09-03 (first published: 2019-08-22)
313 reads
We spread my Fathers ashes over the past weekend. It was one of the hardest things...
2019-09-06 (first published: 2019-08-22)
512 reads
Some 2019 tips for other SQLSat organizers from my last year as lead organizer of SQLSatBR. I hope as a fellow organizer, you can pull some ideas and inspiration...
2019-09-06 (first published: 2019-08-21)
362 reads
One of the powerful aspects of Query Store is the ability to directly query the DMVs for details of historical executions and performance. A key view for this is...
2019-09-04 (first published: 2019-08-21)
316 reads
Based on the great post and script from Wayne Sheffield I decided to try again pre-printing the SpeedPASS for everyone this year. I dislike the line of shame and...
2019-09-05 (first published: 2019-08-21)
227 reads
An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting from a combination of magic beans and smart software developers (I might be wrong about...
2019-08-21
53 reads
In a previous post, I explained how to get Jenkins running in a container for your local CI work. In this one, I’ll expand on the process for database...
2019-08-30 (first published: 2019-08-21)
526 reads
I have an all day seminar I give called “DevOps for the DBA”. If you’re attending, thinking of attending, or you have attended, you might want to have the...
2019-08-21
46 reads
I have delivered a preconf on the biggest conference in Asia. The preconf was about Supervised and Unsupervised Machine Learning with bonus track about Semi-supervised solutions. This was really...
2019-08-21
11 reads
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was scrambling a bit, but since I’ve worked with a few customers in the last year...
2019-08-20
24 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