Notes From SQLSaturday South Florida
Notes from the trip:
Four hour drive between traffic and rain, about an hour longer than I would have liked. The...
2014-06-16
447 reads
SQLAndy
I Gotta See the Code–Question of the Day
I Gotta See the Code is a security question about viewing the code to a stored procedure. Two points if...
2014-06-16
568 reads
Reflections On Fathers Day
Fathers Day coincided with the family vacation this year and maybe more than some years I had the time to...
2014-06-16
526 reads
SQL Saturday South Florida And Then Vacation
I’m leaving early afternoon for the longish drive to South Florida for SQLSaturday tomorrow. The schedule looks impressive! I missed...
2014-06-13
548 reads
SSIS Lessons Learned, Or Not, And Mistakes Beginners Make
It’s been a while since I’ve used SSIS for anything of substantial complexity, and a lot longer than that since...
2014-06-12
800 reads
Giving Away Woodworking Magazines
I read a lot and one of the topics I enjoy reading about is woodworking. Recently I’ve been on a...
2014-06-12
631 reads
SQLSaturday in Vermont, Idaho, South Dakota, Montana, Alaska, Arkansas, Mississippi, and Wyoming
Did the list of states in the title catch your eye? That’s the list of states where PASS is trying...
2014-06-11
521 reads
Status and Name Please-Question Of The Day
Status and Name Please is my latest Question of the Day at SQLServerCentral. This is a fairly easy question, but...
2014-06-11
401 reads
Editorial: Space Hoarders
I wrote Space Hoarders for SQLServerCentral, a discussion of why we – the DBA’s of course – are always blamed for the...
2014-06-10
476 reads
Prepping For The NomCom
Sunday I spent an hour going over various notes and thinking about what I’ve seen in the past couple PASS...
2014-06-09
353 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