Do You Need a Mentor?
When I was young, I never thought I did. I was sure that I knew what was best for my...
2010-11-08
1,039 reads
Pass Summit Sunday Morning
I’m sitting in Top Pot Donut. I’m having a fantastic apple fritter. I’m also trying out the capabilities of the...
2010-11-07
564 reads
Quick Elevators
I’m at the Renaissance in Seattle for a couple days, stuck on the 14th floor. That’s higher than I normally...
2010-11-07
459 reads
SQLPSX 2.3 Release
Just in time for PASS Summit 2010, the CodePlex project SQL Server PowerShell Extensions (SQLPSX) has been updated . Here’s a...
2010-11-06
2,165 reads
2010 DBA of the Year Will be Awarded at SQLServerCentral.com PASS Opening Night Party
Tracy Hamlin, selected as the 2010 DBA of the Year, will be awarded her trophy at this year’s SQLServerCentral.com PASS...
2010-11-06
874 reads
SQLBIGeek’s Function Friday – Return First Date of Month
Brian K. McDonald
SQLBIGeek
Twitter: @briankmcdonald
Welcome to the third post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am...
2010-11-06
540 reads
SQLServerCentral.com Track at SQL Server Has Record Attendance
This past week, November 3-4, the SQLServerCentral.com track at SQL Server Connections has a record 431 attendees. Below are some...
2010-11-06
663 reads
6 Networking Tips for the PASS Summit & A Sunday Invitation
There’s no doubt that the PASS Summit is about learning. In just a few days you’ll max out your learning...
2010-11-06
706 reads
Live Streaming Keynotes From PASS Summit 2010
I just wanted to help spread the word that the PASS Summit Keynotes will be streamed live via LiveMeeting next...
2010-11-05
593 reads
SQLBIGeek’s Function Friday – Return Last Date of the Prior Month
Brian K. McDonald
SQLBIGeek
Twitter: @briankmcdonald
Welcome to the fourth post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am...
2010-11-05
589 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