Red Pyramid
After having read the Percy Jackson series of books, I wanted to read a few more books by Rick Riordan....
2010-10-02
479 reads
Index Black Ops Part 6 – Fill Factor vs. Page Splits
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-10-02
1,609 reads
Strange but True - Report Parameter Label Blank
Here is another one of those strange but true things that I come across every so often which I thought...
2010-10-01
1,518 reads
SQLSat 54
Wow, I have really been kinda slow in the blog department for a couple of weeks now. I have a...
2010-10-01
594 reads
Create Empty Raw File
I need an empty Raw file for my SQL Server Integration Services (SSIS) package. Over the last summer I’ve discovered...
2010-10-01
735 reads
October Question: Tell us about your favorite experience as a participant in the SQL Server community.
There is a thriving world-wide DBA community that offers many opportunties meet other DBAs, to learn from others, and to...
2010-10-01
1,362 reads
Free SQL Server Training for the Week of October 4, 2010
Monday
Quest Software - Advanced SQL Server Troubleshooting - Kevin Kline
Tuesday
PASS Performance Virtual Chapter - Using Storage to Increase Database Performance - Denny Cherry
Wednesday
SQL Lunch...
2010-10-01
1,060 reads
Why Read?
I love to read. Like my friend, Paul Randal (blog, @PaulRandal), I read a lot of books every year, usually...
2010-10-01
356 reads
Index Black Ops Part 5 – Page Splits
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-10-01
882 reads
Presenting at SQLSaturday #48 in Columbia, SC This Weekend
I’m leaving Orlando early Friday morning to drive up to Columbia for SQLSaturday #48 . By the time I changed planes...
2010-10-01
309 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