24 Hours of PASS Wants You…
Calling for Presenters!There’s still a couple months until the next 24 Hours of PASS. Even though it’s a bit of...
2011-01-03
312 reads
Happy New Year 2011
Wish you all a very happy an prosperous New Year 2011. When I see back year 2010 : >> was started my...
2011-01-03
444 reads
Looking Back at 2010
I was “inspired” to write this post after I read some comments on my last post, Reviewing My 2010 Goals,...
2011-01-03
454 reads
MVP 2011
I was awarded the MVP status from Microsoft for 2011 on Jan 1, 2011. This is my fourth consecutive award...
2011-01-03
1,280 reads
Back to Work
It's actually nice to be back to work. It's been a great holiday season for me, lots of family time...
2011-01-03
781 reads
31 Days of SSIS – Using Breakpoints (2/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Today’s post is going...
2011-01-02
576 reads
TPC-E Benchmark Analysis by CPU Type
As an experiment, I decided to import the current official TPC-E results spreadsheet into a SQL Server 2008 R2 database,...
2011-01-01
1,285 reads
31 Days of SSIS – Raw Files Are Awesome (1/31)
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Let’s start off this series with a...
2011-01-01
12,406 reads
January Question: As a DBA, how do you manage your disk space?
Managing disk space is an important responsibility of the DBA, and there are many ways to perform this task. In...
2011-01-01
2,517 reads
31 Days of SSIS – The Introduction
31 Days of SSIS
Last year, Glenn Berry (Blog | @GlennAlanBerry) wrote a series of posts that he called A DMV A...
2011-01-01
2,306 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