2014-01-03
5 reads
Blog Posts
Reblog: December 27 to January 2
Photo credit – Scott Howard
I’ve always been a fan of the feeling when I find an old blog post that’s got...
2014-01-03
365 reads
Speaker of the Month, January 2014
A whole new year. Cool.
I was at SQL Saturday DC, #233, at the beginning of December. I sat through several...
2014-01-03
754 reads
The Powershell Challenge–Notes and Observations
It’s been a month and a half in real time since I started the Powershell Challenge. In that time, I...
2014-01-03
1,217 reads
Throwing Spaghetti At The Wall Isn’t The Worst Plan
I get a lot of email about job opportunities, almost none of which interest me enough to call back about...
2014-01-03
285 reads
Day 9 – Queries Going Boom
This is the ninth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2014-01-02
15 reads
Day 9 – Queries Going Boom
This is the ninth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2014-01-02
996 reads
Happy New Year!
Happy New Year!
Hope you all had a good Xmas, ate too much, drank too much and are still telling yourselves...
2014-01-02
327 reads
How SQL Server 2014 improves Online Operations that aren’t Online Operations
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-01-02
1,063 reads
Master Data Services 2014: Creating nightly load processes
Introduction
A few days ago, I ran into an interesting issue when creating a stored procedure to load new data into...
2014-01-02 (first published: 2013-12-23)
3,504 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