SQLSaturday #59 - Speaker Interview Series # 7 - with Hilary Cotter
He specializes in Microsoft Search solutions and high availability technologies like data...
2010-10-20
1,140 reads
We’ve made great progress with SQLSaturday this year; reaching new cities, a successful handoff to PASS, and a lot of...
2010-10-20
496 reads
This series looks at Common SQL Server mistakes that I see many people making in SQL Server.
Foreign Keys
It’s way too...
2010-10-20
1,314 reads
This shirt was specifically requested by an online friend who shall remain nameless (his name rhymes with “Duck Hoodie”). Another...
2010-10-20
1,101 reads
This past weekend, my wife and I travelled down to Orlando for SQL Saturday 49. I wasn't planning on presenting,...
2010-10-20
414 reads
Tyler Chessman of Microsoft has started a Business Intelligence Users Group in Houston. The group will meet online and onsite quarterly. ...
2010-10-19
1,327 reads
I seldom lose things; I just cannot find them as quickly as I’d like. This is true for keys, tools, and...
2010-10-19
1,679 reads
This is what Task Manager looks like in Windows Server 2008 R2 when you restart the SQL Server Service. This...
2010-10-19
624 reads
In almost 12 weeks time, I’m embarking on a challenge of a lifetime. I’m scaling Africas highest peak, Mount Kilimanjaro...
2010-10-19
463 reads
Over the past two years I have acquired quite a few database servers that I am responsible for. We have...
2010-10-19
472 reads
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 needed to do some research because there is more to #temp tables than...
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
Comments posted to this topic are about the item The Range of Customers
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