Bloggers-Don’t Blog About Spam!
Earlier this week I posted Bloggers, Quit Worrying About Spam, discussing what I felt was an over-focus on preventing spam...
2010-10-27
683 reads
A Little SSMS Wish
IN SQL Server 2000, we didn’t have the fancy-schmancy Management Studio…we had Enterprise Manager and Query Analyzer, and we liked em,...
2010-10-27
519 reads
Vote For The SQLRally Pre-Con Seminars
Do you know a real-life Pointy Haired Boss? Maybe you don’t work for him, but I bet you’ve met one.
In...
2010-10-27
599 reads
Virtual Presentation Tomorrow
I’ll be presenting a practice run at one of my PASS Summit presentations, Identifying Common Performance Problems using Execution Plans,...
2010-10-27
667 reads
SQLSaturday #59 - Speaker Interview Series # 12 with Ayad Shammout
SQLSaturday #59 - Speaker Interview Series # 12 - with Ayad Shammout
Today, we bring you the immaculate interview. If his sessions are as...
2010-10-27
858 reads
The SQL Rally - Who Would I Vote For?
I was looking over the pre-conference sessions submitted for the SQL Rally event taking place next May in Orlando. I...
2010-10-27
843 reads
Postponing SQL Lunch Presentation Until Next Week
I woke up this morning about 3 AM with clogged sinuses and a fever. Great. The changing weather patterns that...
2010-10-27
642 reads
Do You Have Other Opportunities Open?
Imagine you’re talking with a recruiter about a position that seems like a good fit and during that conversation they...
2010-10-27
601 reads
Common SQL Server Mistakes – Functions in the WHERE Clause
This continues my series on Common SQL Server mistakes, looking at more T-SQL mistakes.
What’s Wrong?
If you saw a query like...
2010-10-27
3,453 reads
Have You Grabbed the SQL Sentry Plan Explorer Yet?
I won't say I despise SQL Server Management Studio's (SSMS) display for execution plans, but it's about at that level....
2010-10-27
1,261 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