Bench marking your environment is an important step when introducing new hardware, which is accomplished by running a test workload against the hardware. There are multiple ways to...
2019-10-03 (first published: 2019-09-27)
780 reads
I’ve received several notes of thanks over the last couple of weeks. I’m not sure exactly what’s prompted this sudden outpouring because it’s all been about stuff I’ve done...
2019-09-27
39 reads
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
The post Quick Blog: Run PowerShell Core from...
2019-09-27
24 reads
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
The post Quick Blog: Run PowerShell Core from...
2019-09-27
15 reads
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
2019-09-27
148 reads
TEST You know you are a dad when you start looking at a minivan as a really cool vehicle and marvel at all the features that have zilch to...
2019-09-27
12 reads
Introduction Rob Farley is a Microsoft Certified Master, Microsoft Certified Trainer and is a recipient of the Microsoft MVP Award for SQL Server since 2006. Rob provides consulting and...
2019-09-26
27 reads
TEST I have a new term for the wait my daughter eats food. Instead of please stop wearing food all over your face and eat proper I'm going to...
2019-09-26
10 reads
TEST You know you probably reserved the wrong hotel when you drive around from the back and think it's a condemned building, only to come around the front and...
2019-09-26
8 reads
We often focus on deep analysis and insights generated by machine learning when we talk about Power BI these days because it’s super cool and very fancy. But I...
2019-10-08 (first published: 2019-09-26)
597 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...
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