Sitting in Judgment
I have been meaning to write this for a while, but i wanted to wait for a break in SQLDrama....
2010-10-26
376 reads
SQL Saturday #49 in Orlando - Plus Run SharePoint Locally
Ok so I know this is late, but I wanted to thank Jack, Andy and the team at the Orlando...
2010-10-26
348 reads
Are you Living under a SQLRock ?
I don’t mean a LaRock aka SQLRockstar, but an actual rock.
I was at dinner last week after our all...
2010-10-26
377 reads
You know you want it! - SQLRally Precon Voting
For those of you who have seen our team present, we always do our best to make it really informative,...
2010-10-26
871 reads
Motivational Monday (On a Tuesday)
Hey Gang,
Sorry for the absence. I have been offline for a bit dealing with some family stuff. All if good...
2010-10-26
376 reads
PASS SQLRally Pre-con Voting Is Open
I'm happy to announce that voting for the 2011 PASS SQLRally Pre-con sessions is now open! There are four tracks:...
2010-10-26
402 reads
SQL Rally Cast Your Vote!
Pre Conference seminar voting is up now. Go make it happen! Here's the description of our session:
Title:
Business Intelligence Workshop
Speaker:Patrick LeBlanc,...
2010-10-26
920 reads
SQL Rally: One Day on Query Performance Tuning
The SQLRally, a new PASS initiative taking place in the spring, is going to be a community driven event. This...
2010-10-26
1,073 reads
Bucket List
I have no intentions of kicking the bucket – ever. I have no intentions of getting old either. We’ll see how...
2010-10-26
782 reads
SQLSaturday National Blog Sponsors
With SQLSaturday #49 we tried something I call micro-sponsors, charging $5 for a blogger to sponsor the event. It’s a...
2010-10-26
994 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