Indexing Just Got Easy
As a database professional one of the things that we should be familiar with is the use of indexes. In SQL Server an index helps to improve query performance...
2011-04-01
13 reads
Indexing Just Got Easy
As a database professional one of the things that we should be familiar with is the use of indexes. In...
2011-04-01
665 reads
SQLSaturday#71 is only a day away! - Final Schedule....
Just a final note for all of you planning on attending tomorrow's SQL Saturday #71 event extravaganza up in Boston. The event...
2011-04-01
767 reads
Reflections on Dev Connections / SQL Connections
When SQL Connections in the spring was announced, the folks at Red Gate and SQL Server Central reached out to...
2011-04-01
850 reads
Taking It To The Next Level
Have you set the bar high enough to ensure your success?
You’re reading Taking It To The Next Level, day 5 of 5...
2011-03-31
1,432 reads
PASS Subcommittee
In February I posted this post about the need for Volunteers for SUMMIT 2011. I submitted my application to volunteer. This past week I got word back concerning that...
2011-03-31
6 reads
PASS Subcommittee
In February I posted this post about the need for Volunteers for SUMMIT 2011. I submitted my application to volunteer....
2011-03-31
1,542 reads
To Do: Win Great SQL Training and a Cruise
Wondering what to do when you get a break from work email today?
Make your opening move in a fun contest.
What’s...
2011-03-31
1,908 reads
Hanging with an Inspiration
A long, long time ago, in a state far away, I started writing about technology. At the time, in the...
2011-03-31
1,404 reads
Presenting with a Mac
My name is Brian Kelley and I used to be a PC bigot. That was back in 1989. I was...
2011-03-31
1,574 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