31 Days of SSIS – Controlling Your Flow In The Control Flow (21/31)
Remember, what I said last Friday? I’m going do it, again. Which means, I’m taking the day off. There will...
2011-01-21
938 reads
Disk Partition Alignment–MCM Prep
Does disk partition alignment matter to SQL Server? Without a doubt. When new disk partitions are created, there could be...
2011-01-21
1,462 reads
Free SQL Server Training for the week of January 24, 2011
We're finally getting a handle on things with the new baby. 🙂 As a result, I've started this weekly accumulation of...
2011-01-21
838 reads
PowerShell Week at SQL University – Post 6
Yesterday we went over some loop constructs to get information out of SQL Server. While getting the information out is great, as Data Professionals our very next concern is...
2011-01-21
21 reads
PowerShell Week at SQL University – Post 6
Yesterday we went over some loop constructs to get information out of SQL Server. While getting the information out is...
2011-01-21
1,476 reads
January 2011 Meeting Recap
One week ago today the Las Vegas User group held our monthly meeting. One week ago today, at that meeting, we had our best attendance in over a year....
2011-01-20
14 reads
January 2011 Meeting Recap
One week ago today the Las Vegas User group held our monthly meeting. One week ago today, at that meeting,...
2011-01-20
514 reads
Now Let’s Vote for 24 Hours of PASS
Yesterday, I wanted you to vote for some SQLRally sessions, mine included. Today, let’s vote for the sessions for the...
2011-01-20
618 reads
Policy for Ad-hoc Workloads
During my presentation at SQLSaturday 62 in Tampa I was asked by an attendee about having a policy to check...
2011-01-20
925 reads
Looking Up Email Addresses with PowerShell
A week or so ago Aaron Nelson (Blog|Twitter) put out a call for help on Twitter looking for anyone that...
2011-01-20
13,867 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
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
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