Database Tools Follow-up
After posting a database tools list yesterday, I found that there were things that I had forgotten and a couple of things that i hadn’t even considered. In thinking...
2011-03-18
5 reads
Database Tools Follow-up
After posting a database tools list yesterday, I found that there were things that I had forgotten and a couple...
2011-03-18
603 reads
Are You Taking Advantage of Twitter for SQL Server?
One thing I always do lately, whenever I give a presentation is ask the audience how many of them use...
2011-03-18
888 reads
Teaching Two Classes at University College–University of Denver
I will be teaching two classes for the Spring 2011 Quarter at University College – University of Denver. One will be...
2011-03-18
502 reads
Q & A from 24 Hours of PASS session
Earlier this week I took part in the 24 Hours of PASS live webcast event. There were far more questions...
2011-03-18
708 reads
Twin City Code Camp 10 Is Coming
Twin Cities Code Camp will be hitting the University of Minnesota Campus again next month. This is a biannual event...
2011-03-18
589 reads
SQL Saturday #70 - Tomorrow will be here soon!
We are in the final stages of prepping for SQL Saturday #70, here in Columbia, SC. We have right around...
2011-03-18
732 reads
What is the Most Deployed Database Engine in the World? You’d Be Surprised! It’s Serverless, Self-Contained & Transactional
Just the other week; I was asked to help validate an application database hosted
on a Mac, when I was introduced...
2011-03-18
1,453 reads
Hurry Up and Sign Up! SQL Saturday 70 is Here!
If you are anywhere within driving distance to Columbia, South Carolina, register NOW and then hop in your car Friday...
2011-03-18
434 reads
My Connect Items – Won’t Fix
There’s been some work to close out items in Connect that aren’t going to be fixed. I don’t know exactly...
2011-03-17
884 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