One of most the fun things about working as an Advocate at Redgate is getting to help clients determine their preferred workflow for database DevOps. Teams often have unique...
2020-01-18
23 reads
I’ll admit it, sometimes I’m wrong. Recently I blogged about the usefulness of a newer feature that was enhanced with the release of SQL Server 2019. Resumable Indexes operations...
2021-04-23 (first published: 2020-01-17)
1,309 reads
As a followup to my blog post Azure Data Lake Store Gen2 is GA, I wanted to give some pointers when using ADLS Gen2 as well as blob storage,...
2020-01-24 (first published: 2020-01-16)
440 reads
As always, the scripts in this post can also be found on our Git Hub repo, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/CatagoryControlledAgentJobs.sql Agent jobs, they can be a right pain to manage when you’re...
2020-01-16
43 reads
I ran into a rather obscure permissions problem the other day. Since I wasn’t able to figure it out on ... Continue reading
2020-01-23 (first published: 2020-01-16)
394 reads
2020-01-16
38 reads
Why Use Docker for MSSQL Say you have an onboarding and need to get a new developer up to speed. Have you gone through the setup process for SQL...
2020-01-16
11 reads
Here’s something that seems to keep coming up, but not frequently enough for me to write a blog post about until now: You should not install SQL Server from...
2020-01-15
109 reads
Previously I wrote about In-Memory Optimized Tables, in this blog I am going to discuss how to determine which tables could benefit from being In-Memory by using a tool...
2020-01-23 (first published: 2020-01-15)
469 reads
Thanks to the organizers and many attendees of tonight's Activate Conference Lightning Night at LSU, the first of many series of short-format talks on technology put on by the creatives...
2020-01-15
22 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