Getting a Dedicated Admin Connection
Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need...
2010-12-28
1,204 reads
SQL Server Workload Types and Hardware Selection
There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction...
2010-12-28
2,929 reads
Happy Holidays
I hope everyone is enjoying the holidays. To everyone in the SQL Server community,
Merry Christmas and Happy New Year. Spend...
2010-12-27
971 reads
A Collection of Good Information About Controlling VLFs in SQL Server
Because of the default settings in SQL Server (for the model database), and a lack of understanding about how the...
2010-12-27
568 reads
MCM Live Blog – Week December 27
Watching videos?! Su-ure!
Time for the third week of blogging about the things that I’m doing to study for the MCM...
2010-12-27
560 reads
Meet a New Blogger: Malathi Mahadevan
My friend Malathi (Mala) Mahadevan has chaired the Louisville PASS Chapter for the past couple years, and will be heading...
2010-12-27
983 reads
Why I’m All For 24HOP Showcasing 24 Women Speakers
This is not the HOP you are looking for.
I’ve been thinking about the upcoming 24HOP event planned for March 15...
2010-12-27
972 reads
Rebuilding my laptop
I finally got around to adding the new memory (16GB), removing the old 4GB and then replacing the DVD drive...
2010-12-27
805 reads
MVP Program
There is one thing that have been bothering me for quite some time. I thought I would blog about it....
2010-12-27
1,286 reads
The Twelve Days of (SQL) Christmas
Once upon a time a group of twelve bloggers agreed to each pick a post (or posts) they found interesting...
2010-12-27
1,957 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