See You at SQL Saturday #46 - Raleigh
EDIT: Updated to include a picture of me.
I'm headed up this weekend to speak at SQL Saturday #46 - Raleigh. This...
2010-09-16
827 reads
Rights for one table
I ran across a thread that was asking how to grant rights to a person for one table only, and...
2010-09-16
1,341 reads
Do You Have Influence? Part 1
Most people blog because it’s fun, rewarding, good way to improve writing skills, be cool, and it looks good on...
2010-09-16
1,011 reads
Notes from the Sep 13, 2010 oPASS Meeting
Jack led the meeting tonight, spending a good amount of time on SQLSaturday, and Kendal Van Dyke did his marketing...
2010-09-16
591 reads
Hardware 201:Selecting and Sizing Database Hardware for OLTP Performance
I did a presentation for the fourth hour of 24 Hours of PASS – Fall 2010 today, which was a lot...
2010-09-16
819 reads
What is all that hot air? Oh I'm speaking all over the place!
Many of you have been wondering where I will be speaking next. So I apologize for not replying to you...
2010-09-16
491 reads
Let PASS help you get a job!
With so many folks out there struggling and loking for new opportunities you may want to take some time away...
2010-09-16
335 reads
Ready Set Go
I thought I would pass along something I learned this week about batches in TSQL. I always knew about the...
2010-09-16
378 reads
Presenting At Sarasota SQL Server Users Group On Sept. 21
On Tuesday, September 21, I'll be at the Sarasota SQL Server Users Group to present Paging DR Availability, You're Wanted...
2010-09-15
427 reads
September PASSMN Meeting Next Week
Ever feel like you are all alone? Maybe a little isolated? This month’s PASSMN meeting might bring up these feelings...
2010-09-15
628 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