SQLSaturday#59 Interview Series Continues...with Steve Jones
SQLSaturday#59 Speaker Interview Series #2
Yesterday, on the PearlKnows Blog, I kicked off the SQLSaturday#59 Speaker Interview Series, with a bit...
2010-10-13
818 reads
Common SQL Server Mistakes – Equals NULL
One thing that I don’t see a lot, but it still happens with people new to SQL Server is the...
2010-10-13
21,795 reads
TSQL Tuesday #11: Messages and the Clammy Seduction of the Print Statement
Note: Updated 10/28 based on conversation in the comments, and 12/10 with Denali info.
TSQL Tuesday #11: Misconceptions in SQL Server
This...
2010-10-12
1,011 reads
Why do I contribute to the SQL Server Community?
As an active speaker and volunteer in the SQL Server community I am often asked why do I do it? ...
2010-10-12
548 reads
TSQL Tuesday Misconceptions in SQL Server
I haven’t written a post for a TSQL Tuesday for a little while and I know that I’m late getting...
2010-10-12
1,077 reads
Slides and Demo from Midlands PASS Presentation - October 12, 2010
Here are the slides and demo script from the presentation on Understanding SQL Server Query Processing.
2010-10-12
551 reads
Lightening Talk On Covering Indexes Ka-chow! Ka-chow!
“I’m a precision instrument of speed and aerodynamics.” That’s what Lightning McQueen tells Mater when they first meet in Cars....
2010-10-12
405 reads
Lightening Talk Ka-chow! Ka-chow!
“I’m a precision instrument of speed and aerodynamics.” That’s what Lightning McQueen tells Mater when they first meet in Cars....
2010-10-12
1,324 reads
Speaker Gift for SQLSaturday #49
We’ve tried to move away from shirts as a speaker gift, most speakers have them so we only get them...
2010-10-12
508 reads
SQL Saturday New England: The New Date
The real world can get in the way of important things like SQL Saturday. In the case of SQL Saturday...
2010-10-12
569 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