31 Days of SSIS – Generating Row Numbers (23/31)
31 Days of SSIS
It’s Sunday afternoon and a good time to be putting up post twenty-three for the 31 Days...
2011-01-24
2,499 reads
SQL Saturday #45 Report
This past weekend I attended another SQL Saturday. This one was held in Louisville, KY. Malathi Mahadevan and her volunteers...
2011-01-23
1,355 reads
PASSMN January Meeting This Week
Don’t forget – if you are in Minnesota this week the Minnesota SQL Server User Group (PASSMN) will be meeting on...
2011-01-23
528 reads
Internals and Performance class in Dallas
At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...
2011-01-23
4,030 reads
SQLskills Master Immersion Events 2011
Last year, I tried to attend one of Paul Randal’s and Kimberly Tripp’s SQL Immersion Events, but it conflicted with...
2011-01-23
605 reads
2011 Goals
Last year I posted professional goals along with quite a few other bloggers and it helped to keep me somewhat...
2011-01-23
772 reads
2010 Goals Review
So… this is late. And I missed my q3 goals review all together. Oh well, not much I can do...
2011-01-23
734 reads
Tampa IT Camp Saturday
The first annual Tampa IT Camp will be held on Saturday, March 19th 2011.
What’s an IT Camp?
In the...
2011-01-22
579 reads
31 Days of SSIS – Data Flow Expressions (22/31)
31 Days of SSIS
Today, we continue on with the 31 Days of SSIS blog series. Yesterday’s post was on the...
2011-01-22
2,340 reads
SSMSDeploy 1.5 Available: new configuration form and highly tweaked request list
SSMSDeploy version 1.5 is ready. This one has a LOT of GUI tweaks. No database changes in this one, so...
2011-01-22
962 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