Invitation to T-SQL Tuesday #014
Hello and welcome to the first T-SQL Tuesday of 2011!
2010 was a great year for T-SQL Tuesdays, dreamed up and...
2011-01-04
1,303 reads
MCM Live Blog – Week January 3
Watching videos?! Su-ure!
Surprisingly it’s now my fourth week of blogging about the things that I’m doing to study for the...
2011-01-04
274 reads
MCM Prep - Only ONE Transaction Log File
Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves...
2011-01-04
781 reads
My 2010 Year in Review
While in Cincinnati for the first time since September of 2007, I heard on several occasions that I work too...
2011-01-04
404 reads
31 Days of SSIS – Data Flow Breakpoints?! (3/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. In yesterday’s post I...
2011-01-04
546 reads
Lots of Intel Sandy Bridge News Today
Intel has lifted the embargo today on 32nm Intel Sandy Bridge benchmarking, so there is a lot of good information...
2011-01-03
858 reads
RTFM365, Week 4
The days are just flying. I have to admit: I may have missed a day or two in the rush...
2011-01-03
497 reads
Most Popular SQL Server Events
I recently held a poll on my blog, asking people if they had attended any SQL Server events in the...
2011-01-03
756 reads
Looking Back at 2010
I was “inspired” to write this post after I read some comments on my last post, Reviewing My 2010 Goals, and I read Brent Ozar’s post, Goals? Where we’re...
2011-01-03
8 reads
Beginning Powershell Companion PDF
Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...
2011-01-03
2,695 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