January ’11 Meeting Reminder
If you saw my blog post the other day, you know that S3OLV has a meeting this Thursday (Jan 13,...
2011-01-13
469 reads
How to Obtain and Install SQL Server Service Packs and Cumulative Updates
If you are in charge of one or more SQL Server instances, whether they are on a laptop, or a...
2011-01-12
2,943 reads
Why Do All Funnel Charts Look The Same?
Something recently occurred to me. I’ve been researching chart and dashboard
design standards for an article I’m working on, and the...
2011-01-12
669 reads
31 Days of SSIS – UnPivot Alternative (12/31)
31 Days of SSIS
This is the twelfth post in the 31 Days of SSIS blog series. This post is going...
2011-01-12
1,011 reads
Technical Goals for 2011
I know I missed out on the massive meme yesterday (T-SQL Tuesday #14), but I blame dealing with the weather...
2011-01-12
799 reads
What the heck is going on? Industry news, shake-ups,depatures, old controversies and new beginnings
What the heck is going on? Industry news, shake-ups and departures.
It's only two weeks into the New Year 2011, but there's...
2011-01-12
1,744 reads
Intel Processor Information
Here is a small collection of links to tools for measuring and evaluating mobile and desktop processors, along with some...
2011-01-11
1,222 reads
Resolutions For 2011
This post is a part of T-SQL Tuesday, a monthly event where SQL bloggers post about a common topic. This...
2011-01-11
677 reads
What’s Going On at Microsoft?
Last week Donald
Farmer announced that he was leaving his long-time position as Microsoft’s lead
BI technology evangelist for QlikTech, a small...
2011-01-11
708 reads
January Baton Rouge SQL Server User Group
The Baton Rouge SQL Server User Group will be hosting its first meeting of the new year. Our meeting place...
2011-01-11
1,432 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