May 2011 S3OLV Meeting Reminder
This is a quick reminder of the upcoming May meeting for the Las Vegas SQL Server Users Group. We will be meeting on May 12, 2011 at the usual...
2011-05-10
9 reads
May 2011 S3OLV Meeting Reminder
This is a quick reminder of the upcoming May meeting for the Las Vegas SQL Server Users Group. We will...
2011-05-10
526 reads
My Public Events RoundUp
As a part of my careers goals, I am trying to remain involved in the community through various engagements and events. Recently, I was able to present to the...
2011-05-10
13 reads
My Public Events RoundUp
As a part of my careers goals, I am trying to remain involved in the community through various engagements and...
2011-05-10
682 reads
T-SQL Tuesday #18 – CTEs
To CTE or not to CTE, that is the Question So my post really has nothing to do with the title. This is not a post to help you...
2011-05-10
8 reads
T-SQL Tuesday #18 – CTEs
To CTE or not to CTE, that is the Question
So my post really has nothing to do with the title....
2011-05-10
693 reads
DevConnections Germany Offers SQLServerCentral.com Track
SQLServerCentral.com will be offering a SQL Server track at the upcoming DevConnections in Germany this June.
The Germany DevConnections will be...
2011-05-10
1,089 reads
DevConnections Germany and DevConnections London Offers SQLServerCentral.com Track
SQLServerCentral.com will be offering SQL Server tracks at both the upcoming DevConnections in Germany and the UK this June.
The Germany...
2011-05-10
894 reads
100% Microsoft?
Reprinted from my editorial in Database Weekly.
When I was a junior DBA many years ago (even before the company I...
2011-05-10
563 reads
PASS Summit Cometh, and That Right Soon
Look at the cute bunny. Now go vote for me.
I can see October from here, and it’s coming at about...
2011-05-10
530 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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