T-SQL Tuesday #051: Always Hedge Your Bets
It's time for T-SQL Tuesday again and this month's host is my former co-worker, the @SQLRNNR himself, Jason Brimhall. Jason's...
2014-02-11
723 reads
Blog Posts
T-SQL Tuesday #51 – Place Your Bets
It’s T-SQL Tuesday time again and Jason Brimhall is hosting this month’s event. He used to live in Las Vegas,...
2014-02-11
789 reads
T-SQL Tuesday#51 - Place Your Bets - In-Place Upgrade.
I’m not much of a
betting man, but if I had to bet that I would participate in this month’s T-SQL
Tuesday...
2014-02-11
2,013 reads
Using PowerQuery with Email
At our last MVP summit, I sat in on a session on PowerQuery. Our presenter, who is pretty passionate about...
2014-02-11
338 reads
Who are your victims?
Or….deadlock notifications.
In my previous post I talked about having your own database(s) and what information you could be collecting. One...
2014-02-11
596 reads
Why I just became a Microsoft Employee
I have been an independent consultant (IC) for quite a while now. In an amazing number of coincidences, or just plain...
2014-02-11
1,508 reads
Why is Your SQL Server Slow? Here’s a Hint
I was talking recently with my friends and former colleagues at Idera about the things that slow down SQL Server....
2014-02-11
1,086 reads
Building an SSMS Add-In Using Redgate Ecosystem
On Friday I was finally able to spend a couple hours looking at the Redgate Ecosystem, which is essentially a...
2014-02-10
1,022 reads
Check your SQL Agent history settings before it’s too late!
A little while back I was doing some research into a failed job and ran into a slight problem. The...
2014-02-10
901 reads
Do Not Set Maximum Ram To 0 Ever - Mistakes We Make
I'm going down memory lane here and remembering one of the first things I did as a DBA. I was...
2014-02-10
613 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