Flyclear Revisited
Back in May I wrote about signing up for FlyClear as a way to save time travelling and in doing so,...
2008-10-14
524 reads
SQLAndy
Should I Run for the PASS Board of Directors?
I saw the recent Call for Nominations for the election this year, so the title of this post is only...
2008-10-13
521 reads
Post Event Notes on SQLSaturday #5 & SQLSaturday #9, and Future Plans
Thought I'd post these notes based on feedback from the event organizers, wasn't able to attend myself due to scheduling...
2008-10-13
540 reads
SQL Server MVP
Can't say I ever expected to say this, but as of October 1st I'm a SQL Server MVP. A nice...
2008-10-13
881 reads
Do You Understand Microsoft Licenses?
I had an email from a friend recently asking about a licensing question pertaining to Microsoft. It reminded me of...
2008-10-09
542 reads
Tethering vs Air Card & Other Miscellaneous Phone Thoughts
I've been using a Blackberry Curve for a while and I'm been entirely happy with it. Great phone, great battery...
2008-10-08
535 reads
Do You Love PASS?
Recently Tony Davis posted some thoughts (almost a rant) about his opinions of PASS, and there is a great follow...
2008-10-07
699 reads
Notes on Went Well & What We Could Have Done Better - From SQLSaturday #8
As I mentioned yesterday things went pretty well, but always room for improvement. Here are some notes, if nothing else...
2008-10-06
298 reads
Final Reminder - SQLSaturday #5 & #9 Coming Up on October 11, 2008
You can find details about these great free events at www.sqlsaturday.com. It's definitely been interesting watching them grow from afar...
2008-10-06
313 reads
Thoughts on IndyTechFest 2008
I'm writing this as I wait on a flight back to Orlando after spending yesterday with John Magnabosco and team...
2008-10-05
165 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