Re-Awarded MVP for 2011
I received my notice that I was renewed as a MIcrosoft MVP for SQL Server for 2011. It's a nice...
2011-01-01
785 reads
MVP Award for 2011
I just received notification from the Microsoft MVP Award Program that I’ve received the MVP award for SQL Server for...
2011-01-01
749 reads
Easy CDC part 2: Automating a Quick Initial Load, and Some Gotchas
Introduction
A couple of weeks ago I made this post about quickly building a CDC system against a vendor ERP database....
2011-01-01
1,339 reads
2010 Goals Review
I started the year with 10 Goals for 2010 and now I'll end it by looking at how many of...
2010-12-31
1,596 reads
XQuery for the Non-Expert – Substring() Function
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Within the...
2010-12-31
1,777 reads
Happy New Year
Well it’s Friday again and another big day.
Hopefully you all had a great Christmas and as we move to...
2010-12-31
1,500 reads
2010 - A Year without Specific Goals
In previous years I had set goals and even if I didn't fully achieve them, they were helpful in giving...
2010-12-31
2,107 reads
The Year of Change: 2010 In Review
Like clockwork, another year has come and (almost) gone. It’s been a wild year on many fronts: major happenings included...
2010-12-31
1,594 reads
Blogging on Blogging
So I must confess that my blogging efforts to date have been on the impersonal side
– perhaps even a bit...
2010-12-31
1,461 reads
Quick MCM Prep Help
Before I went on vacation, I mentioned I was downloading some of the MCM videos from Technet.I had grabbed 4...
2010-12-31
1,624 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