SQLSaturday Update (Aug 1, 2008)
SQLSaturday #5 in Olympia is progressing nicely. 85 registered, venue locked in, and work under way for fund raising via...
2008-08-01
564 reads
SQLAndy
Tool Review: Hamachi VPN
Maybe I haven't looked at the right products, but two years ago when we needed a VPN solution there wasn't...
2008-07-31
1,492 reads
Operation Hands Free
Recently I was driving home and as I made that turn into the sub-division where I live, over the course...
2008-07-30
1,358 reads
Blogging on SQLServerCentral.com
Recently my friend Steve (managing editor of SSC) posted to his blog about The Bad Karma Project that has to...
2008-07-30
1,371 reads
Tool Review: Servers Alive
Not all of us work at companies big enough to justify the expense/time it takes to implement something like MS...
2008-07-29
1,449 reads
Rebuilding Stats: Twice or Not at All Posted on SSC
Rebuilding Stats was published yesterday on SSC, some nice comments posted to it as well. The main point of the...
2008-07-29
1,478 reads
IP6 Addresses Could Break Your DB
I saw this post from Rick Strahl about IP6 Addresses in Vista breaking some code, and it immediately made sense...
2008-07-28
1,446 reads
Tool Review: Microsoft Virtual CD-ROM Control Panel
It's downright common these days to download programs as ISO images, but XP doesn't have a native viewer for them....
2008-07-27
1,704 reads
Blogging Thoughts - Part 2
Earlier I wrote Blogging Thoughts - Part 1 where I discussed the various approaches I've seen in blogs (blogging when you...
2008-07-24
1,346 reads
Tool Review: TaskSwitchXP
For longer than I care to count I've used the Alt-Tab Powertoy from MS to get a nicer view of...
2008-07-23
1,294 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
Question of the Day
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