On Saturday May 2 Christine and I are presenting at the Data Community #DataWeekender Europe 2020 online conference, an all-online free virtual popup Microsoft Data Conference hosted by various professionals...
2020-05-02
19 reads
(2020-May-01) There is a current limitation in Azure Data Factory (ADF) to accept only two conditions for the OR function.You won't be able to specify the following expression to evaluate...
2020-05-19 (first published: 2020-05-01)
1,423 reads
Time for my monthly progess report on goals. I set goals and had an update last month. This month, I’ve had a reminder for 4 days that says “work...
2020-05-01
22 reads
My day to day work machine is a Windows 10 HP laptop. It remains docked at my desk where it happily helps me to go about my daily business. ...
2020-05-01
12 reads
My day to day work machine is a Windows 10 HP laptop. It remains docked at my desk where it happily helps me to go about my daily business. ...
2020-05-14 (first published: 2020-05-01)
408 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-05-01
21 reads
Following on from my Learner’s Guide to SQL Server Performance Triage, I’m tackling Query Tuning. In this guide, I’m experimenting with an outline style rather than expanding each paragraph....
2020-05-18 (first published: 2020-05-01)
1,002 reads
As many of you know, Query Store is a wonderful tool for identifying query regressions, which in turn makes it an equally wonderful tool for migrations involving an upgrade...
2020-04-30
27 reads
This tip comes from my DBA days working with SQL Agent Job schedules. If you’ve ever worked on a server where many people created job schedules you’ll know exactly...
2020-05-19 (first published: 2020-04-30)
323 reads
Clumio’s Rapid Recovery is amazing, and you should know more about it. You might not have heard of Clumio before. Clumio is an upstart SaaS-based backup solution for both...
2020-05-15 (first published: 2020-04-30)
379 reads
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
By Steve Jones
This month we have a new host, which I am grateful for. So many...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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