SQLRally Call for Presenters
Go SQL! Go SQL! I haven’t blogged about it until now. If you weren’t aware, there’s a new conference in...
2010-12-06
378 reads
Review: Idera SQL Doctor
Recently, a co-worker practically slammed me up against the wall, exclaiming “You have to check out this new tool, right...
2010-12-06
2,606 reads
Moving Windows in Windows 7
I had my laptop connected to a projector recently, and for some reason a few windows got moved off screen,...
2010-12-06
567 reads
My Weekend
We are now well into December and Christmas is fast approaching, I have most, but not all of my shopping...
2010-12-06
521 reads
Consolidation
I’m about to go down one laptop, which is good. I have had too many for some time. Right now...
2010-12-06
398 reads
The Basics of Troubleshooting
After seeing several cases in the past couple of months where I felt the basics of troubleshooting were violated, I...
2010-12-06
2,226 reads
Digg
I’m currently doing some experiments with ,y blog and trying out digg.com. In order to do that I need to...
2010-12-05
529 reads
What happens when a query is submitted?
I know, We cant cover life span of query in short. here is my another try to list some high level information...
2010-12-05
5,439 reads
What PASS means to me.
I first heard of PASS (Professional Association for SQL Server) in connection with the PASS Summit. I had a several...
2010-12-04
356 reads
Getting Drive Info, Part 5, the SSIS WMI Data Reader Task
In the final installment of the Getting Drive Info series (Part 1, Part 2, Part 3, Part 4), SSIS will again be used to collect and save the drive...
2010-12-04
21 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