Women in Technology SQL Lunch!
Attend SQL Lunch...the power of my sweater compels you...
This week on Friday, March 17 we’re having a free panel talk,...
2011-03-17
667 reads
Where does slow performance come from?
I have my opinions and experience, and I’ve no doubt you have yours. Paul Randal (blog|twitter) has put up another...
2011-03-17
745 reads
Database Tools
Recently I have posted a couple of articles about various database or SQL tools either for maintenance or for benchmarking. Those posts work well in conjunction with a post...
2011-03-17
11 reads
Database Tools
Recently I have posted a couple of articles about various database or SQL tools either for maintenance or for benchmarking....
2011-03-17
4,457 reads
SQL Lunch #51–SQL U Presents Women in Technology
This week I am happy to announce the second SQL University SQL Lunch presentation. What’s makes this exciting is that...
2011-03-17
1,151 reads
DevWeek 2011 – A DBAs view
The title itself would lead you to believe this conference was only for the those looking to master the art...
2011-03-17
825 reads
There’s A New North Central Regional Mentor
What has two thumbs and just signed on to be a PASS Regional Mentor? This guy!
Over the past couple weeks,...
2011-03-17
698 reads
SQL Server Denali CTP1 Diagnostic Information Queries
Here is the first SQL Server Denali–specific version of my Diagnostic Information Queries. There are actually only two queries (which...
2011-03-16
1,016 reads
Balancing Work and Life
Balancing work and home life is nothing new; we’ve had this challenge for a long time. But in recent months when so many companies are streamlining operations and asking...
2011-03-16
9 reads
Balancing Work and Life
Balancing work and home life is nothing new; we’ve had this challenge for a long time. But in recent months...
2011-03-16
1,028 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