Three Turns On The Road
Huh? My story? Okay. It was never easy for me. I was born a poor black child. I remember the...
2010-02-16
1,123 reads
Huh? My story? Okay. It was never easy for me. I was born a poor black child. I remember the...
2010-02-16
1,123 reads
If you read Fundamentals of Storage Systems – Stripe Size, Block Size, and IO Patterns you know I built a little...
2010-01-19
1,332 reads
If you have been following this series we have covered system buses, hard disks, host bus adapters and RAID. Along...
2010-01-04
46,964 reads
It’s been a busy year for me. Last year I quit traveling and took a 8 to 5 job so...
2010-01-02
773 reads
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...
2009-12-15
4,053 reads
We have covered the Hard Disk and the System Bus. This time around we will cover disk controllers and host...
2009-12-11
3,898 reads
In the last RAID article we covered the basics. This is a little deeper dive into the underlying mechanics of...
2009-12-08
1,525 reads
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...
2009-12-07
8,944 reads
We have covered the Hard Disk and the System Bus. This time around we will cover disk controllers and host...
2009-12-03
6,476 reads
12/03/2009 - UPDATE! There were a couple of bugs in the SQLIOCommandGenerator new SQLIOTools.zip has been updated.
------------------------------------
I often tell people one...
2009-12-02
1,578 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