Have You Heard? You Can Get a Mentor
Steve Jones and Andy Warren are at it again. The founders of SQLServerCentral, SQLShare, and SQLSaturday have started a new program, The Mentoring Experiment, to try to match professionals...
2011-04-28
10 reads
SQL University: SQL Azure & PowerShell
Welcome once more to the Miskatonic branch of SQL University. I see that most off you survived out last encounter…...
2011-04-28
1,731 reads
How to determine the current SSIS runtime environment
If you want to test if you’re currently debugging an SSIS package via BIDS/Visual Studio, or running normally via DTExec,...
2011-04-28
2,413 reads
Powershell Day 28
Day 27 SQL Policy I highly recommand to go through the Policy –based management (BCM)’s official excellent site to learn...
2011-04-28
521 reads
Have You Heard? You Can Get a Mentor
Steve Jones and Andy Warren are at it again. The founders of SQLServerCentral, SQLShare, and SQLSaturday have started a new...
2011-04-28
710 reads
MS Certs Exam price is rising …
Today Marlon Ribunal twittes come with new info about MS Certifications exams are rising…
This is not a good news, so...
2011-04-28
750 reads
DevConnections – Heavily Discounted Passes !
DevConnections – London June 2011
DatabaseExpertise has negotiated 10 tickets for the main 2 day conference, at an amazing price of £100!!!
The first...
2011-04-28
706 reads
Daily Denali Delight – Day 6
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-28
807 reads
A SQL Server Hardware Nugget A Day – Day 27
For Day 27 of this series, I am going to talk a little bit about disk performance and one easy...
2011-04-27
1,319 reads
It’s a Deal, It’s a Steal…
Its the sale of the century. To coin a cleaned up phrase from a Guy Ritchie film (either Snatch or...
2011-04-27
643 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