MCM Exam – Take 2
Yesterday, I went in for my re-take of the MCM written exam. If you recall, I failed the exam last...
2011-03-29
576 reads
#SQLSat67… it’s mystery is only exceeded by it’s power.
We’ve seen a few summaries come through by now, so I’m going to throw mine into the mix. To recap...
2011-03-29
681 reads
On Leadership - Lead from the Front
This topic actually came up at SQL Saturday #70 - Columbia, SC. I spent the first 15 years of my life...
2011-03-29
2,164 reads
Think Like a Customer
This is the most important and essential first step for a DBA on the journey to providing outstanding customer service....
2011-03-28
856 reads
Oracle Drops the Bomb
The below information has been taken from SSWUG.org.
Oracle Drops the Bomb
Since the purchase of Sun and it’s holdings by Oracle...
2011-03-28
820 reads
MidnightDBA: We do a lot
We do a lot of things. It’s difficult to explain all the things we do to people. So I made...
2011-03-28
614 reads
SQL Saturday #67 Wrap-up
Just… Wow. What an event. What a great group of people. I’m just so lucky to be involved with fantastic...
2011-03-28
923 reads
On the Move to SQL Server Connections
Brian Kelley, speaking on the SQLServerCentral track.
A bit of a crazy day for me, starting off a crazy week. I...
2011-03-28
748 reads
ShowPlan XML
I just ran into something that I hadn’t noticed in SQL Server. It struck me as somewhat interesting but is really not too big of a deal. While demonstrating...
2011-03-28
22 reads
ShowPlan XML
I just ran into something that I hadn’t noticed in SQL Server. It struck me as somewhat interesting but is...
2011-03-28
1,938 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