People are talking about you
I was listening to a friend give a presentation on getting a job recently. In the presentation, Chris Shaw, the...
2010-09-27
969 reads
Food Drive
Don’t forget the food drive tomorrow for SQL Saturday #52 in Colorado. Please bring food, or even clothing/blankets, that can...
2010-09-24
631 reads
Free SQL Server Training for the Week of September 27, 2010
Tuesday
PASS Application Development Virtual Chapter - Next-Level SQLCLR: Parallel Processing and Bulk Load - Adam Machanic
Pragmatic Works - Performance tuning the cube - Adam...
2010-09-24
777 reads
A day of rest
Not quite a day of rest, likely some chores in advance of another busy weekend at the ranch.
I’m taking today...
2010-09-24
719 reads
A Little Help with Azure Please
Not long ago Microsoft announced a new product called Azure AKA “SQL Server in the Cloud”. I have to say...
2010-09-23
329 reads
Is It that Time Again?
Yes, it is. As I mentioned a few months back, it is important to pay attention to when Microsoft releases...
2010-09-23
513 reads
COMPUTE: now it is going, what else will do it?
/*I'd be very surprised if you've ever used the old COMPUTE clause in SQL Server. It is a bit mad,...
2010-09-23
1,628 reads
PASS Elections – Improving the Process
Since there has been a bit of a furor over the PASS election process the past 2 years I thought...
2010-09-23
479 reads
Common SQL Server Mistakes – Multi Row DML Triggers
How often have you seen someone write a DML trigger like this:
createtrigger mytrigger on Mytable forinsertas
declare @id int
select @id = id...
2010-09-23
15,415 reads
Microsoft Releases SQL Server 2008 SP1 Cumulative Update 10
On September 21, 2010, Microsoft released SQL Server 2008 SP1 Cumulative Update 10, which is Build 2799. I count 29...
2010-09-22
1,297 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