MCM Live Blog – Week January 10
Watching videos?! Su-ure!
Week five and it seems like time is going by faster than I had expected it would. As...
2011-01-11
286 reads
T-SQL Tuesday: Resolutions
In my invitation to T-SQL Tuesday #014, I picked the topic “Resolutions”, clearly to play on the new year. The...
2011-01-11
759 reads
January 2011 S3OLV
Tis the calm before the storm. At least it feels like that. The invites have all been sent. The presenter lined up. Reminders have been sent and now we...
2011-01-11
8 reads
January 2011 S3OLV
Tis the calm before the storm. At least it feels like that. The invites have all been sent. The presenter...
2011-01-11
472 reads
Making It Right
Last week Jonathan Kehayias (Blog|Twitter) used his blog to publicly call out Thomas LaRock (Blog|Twitter). I am not going to...
2011-01-11
665 reads
T-SQL Tuesday 14: Techie Resolutions for You not Me
Is it just me or has the community done the whole “What are my goals for this year” thing to...
2011-01-11
656 reads
SQLBits Will be Held in Brighton England in April
SQLBits, the largest SQL Server conference is Europe, will be held this April 7-9, 2011 in Brighton, England at the...
2011-01-10
562 reads
DevTeach/SQLTeach Montreal 2011 Registration is Now Open
The recently resurrected DevTeach/SQLTeach event will be held May 31 through June 2, 2011 in Montreal, Canada at the Montreal...
2011-01-10
650 reads
Speaking at SQLSaturday #62–Tampa
I’ll be speaking at SQLSaturday #62 – Tampa this Saturday, January 15th. I’ll be presenting: Why I Use Stored Procedures With the...
2011-01-10
10 reads
Fun with Extended Properties in SQL Server 2008
Most technical professionals don’t seem to enjoy writing and maintaining documentation for their databases. I know that documentation falls pretty...
2011-01-10
3,400 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