March SSSOLV Reminder
This is just a quick reminder about the meeting coming up on March 10, 2011 at 6:30 PST. You can...
2011-03-07
466 reads
SQLServerCentral Best Practices Clinic
I have just begun a new article series at SQLServerCentral.com called the SQLServerCentral.com Best Practices Clinic. What is this series...
2011-03-07
661 reads
An Outpouring From The Twitter Community
Last week, I was in Redmond, Washington, for the Microsoft MVP Global Summit. This was my fourth time attending the Summit; it’s a great opportunity for networking and providing...
2011-03-07
5 reads
An Outpouring From The Twitter Community
Last week, I was in Redmond, Washington, for the Microsoft MVP Global Summit. This was my fourth time attending the...
2011-03-07
937 reads
The Three C’s Of Interviewing
A client of mine recently asked me to help fill a junior-level position in their organization. This isn’t uncommon; I regularly help clients interview and select qualified IT Professionals...
2011-03-07
8 reads
The Three C’s Of Interviewing
A client of mine recently asked me to help fill a junior-level position in their organization. This isn’t uncommon; I...
2011-03-07
1,041 reads
SSWUG DBTechCon Coming Up
Over the last few years, I’ve blogged about and spoke at the SSWUG Virtual Conferences. It’s that time of the...
2011-03-07
479 reads
IT Camp Saturday
The first ever IT Camp is being held in Tampa on March 19, 2011, organized by cool Tampa guy Chad...
2011-03-07
622 reads
SSAS – Changing the Dimension ALL Member Name
All Analysis Services dimensions have a default All member that represents all the members for a particular attribute.For example, let’s...
2011-03-07
2,169 reads
Execution Plan Stability
I’ve talked before about one of the primary things that the Query Optimizer team at Microsoft tries to avoid, regressions....
2011-03-07
787 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