31 Days of SSIS – Pivot Transformation (10/31)
A few months back, well before the 31 Days of SSIS started, I had been playing with the Pivot Transformation. ...
2011-01-10
1,192 reads
Top 10 SQL #Awesomesauce for 2010
Here at MidnightDBA.com, we’re all about you! And us! It’s just us, and you. Which is why I’ve put together...
2011-01-10
810 reads
Speaking at SQLSaturday #62–Tampa
I’ll be speaking at SQLSaturday #62 – Tampa this Saturday, January 15th. I’ll be presenting:
Why I Use Stored Procedures
With the proliferation...
2011-01-10
772 reads
SSC Editorial: Clouds in our Future
I wrote Clouds in our Future to see if I could spark a good conversation about the mental shift required...
2011-01-10
608 reads
How SQL Server stores indexes on variable length columns
In the last months I had done a lot of performance tuning workshops, and there is
almost the same question: How...
2011-01-10
2,377 reads
Updated SSMSDeploy Demo Video
This is just a quick note before I head off for work that I have made a new demo video...
2011-01-10
642 reads
SSAS – Hiding Unknown Member
You may have noticed when creating Analysis Services dimensions that a member is created in all of your attributes that...
2011-01-10
14,907 reads
PASSMN Call for Presenters and Sponsors
Before the year gets going too far and things are too planned out, I thought I would see if there...
2011-01-10
417 reads
My First Sandy Bridge Desktop System
I was standing in line at the Denver Micro Center at 11AM this morning (despite the beginnings of a small...
2011-01-10
1,406 reads
Thinking about goals for 2011
The SQL community is inspiring, and there are a lot of people that work hard to contribute to it. With...
2011-01-10
1,034 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