So, This Happened Today…
It started like any other Monday following a long holiday weekend. Hundreds of emails to filter through, a new client...
2013-12-03
506 reads
Blog Posts
SQL in the City and SQL Saturday–Washington DC
Actually, Maryland, but close enough. I’ll be in Chevy Chase this weekend, first for our SQL in the City Seminar...
2013-12-03
694 reads
Upcoming Special Events for the Baton Rouge SQL Server User Groups
I'm happy to announce a big slate of upcoming events for Baton Rouge User Groups and especially the SQL Server...
2013-12-03
642 reads
Webinar Q&A: Practical SSAS: Getting Started with Analysis Services
A couple of weeks ago I did two webinars for the Pragmatic Works Free Training on The T’s. The first...
2013-12-03
1,266 reads
Webinar Q&A: SSIS Design Patterns for Loading a Data Warehouse
I’m not going to sugar coat it. I’ve been a bit of a slacker lately. Unfortunately I didn’t get the...
2013-12-03
1,584 reads
December 2013 – Monthly SQL Server Checklist
image source
The holidays are upon us and it’s the first Monday in December. That means it’s time once again to...
2013-12-02
475 reads
Digging Around For Free Tools – BitBucket
Digging Around In BitBucket BitBucket was very thin when it comes to SQL Server. I did find a couple of interesting projects that may appeal to others as well...
2013-12-02
19 reads
Digging Around For Free Tools – BitBucket
Digging Around In BitBucket
BitBucket was very thin when it comes to SQL Server. I did find a couple of interesting...
2013-12-02
923 reads
Index Rebuild Status Update And Giveaway!: Quick Tips
I have a Free 1-Month code to PluralSight. There's no catch or gimmick, If your comment is in this post,...
2013-12-02
493 reads
Last Weeks Top “Reading” Links #60
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-12-02
1,122 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