Some time back I wrote about the new data classification features in Azure and SQL Server Management Studio. If you’ve done quite a bit of work classifying your data...
2020-04-24 (first published: 2020-04-11)
1,002 reads
I recommend leaving the hyper-threaded logical cores enabled in the host BIOS, but not depending on them for performance gains. Hyperthreaded CPU cores, or logical cores, should not be...
2020-04-21 (first published: 2020-04-10)
1,613 reads
I started this on Facebook, privately with friends. I heard about it from one of them and liked it. I didn’t get many guesses, so I took a chance...
2020-04-10
257 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-10
23 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-09
19 reads
I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at some of the learnings from the 2020 State of Database DevOps report. I’ll be discussing...
2020-04-09
32 reads
I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins from Redgate. I posted the release of the SQL Prompt fix (here: ). The teams...
2020-04-15 (first published: 2020-04-09)
1,865 reads
A little while ago, Ray Kim (blog | twitter) asked a few folks who organize SQL Saturday events a few questions for his blog. The results are in and...
2020-04-09
12 reads
I downloaded SSMS 18.5, as there were a lot of fixes in here and thought this was a good upgrade to try. I’d heard reports of major changes in...
2020-04-08
2,250 reads
I was excited to try the Jupyter Book feature in the March Azure Data Studio (ADS) release. I’ve thought notebooks were an interesting way to teach and I’m looking...
2020-04-22 (first published: 2020-04-08)
330 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