DBA Myths: Can a differential backup get bigger than the full backup?
The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one...
2019-03-04 (first published: 2019-02-14)
2,455 reads
Blog Posts
Informix on Docker
Today we will discuss how to install/configure informix on Docker, >docker run -it –name ifx –privileged -p 9088:9088 -p 9089:9089...
2019-03-04
851 reads
Partitioning 3: Beyond just partition elimination
In Partitioning 2, I showed how to analyze which partitions were accessed by our Index Seek. However, we were searching...
2019-03-04 (first published: 2019-02-14)
1,869 reads
Speaking at Techorama 2019
I’m delighted to announce I’ll be giving a talk at Techorama 2019. It’s one of the best events I’ve ever been to and I’ll be in the good company...
2019-03-04
12 reads
Speaking: Rochester SQL Server User Group March 2019
Probably a bit late getting this posted but I will be speaking at the March 5, 2019 meeting of the Rochester SQL Server User group (RSVP link). I don’t...
2019-03-04
3 reads
system_health Extended Events in Azure SQL Database
The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management that is 2008 or greater. Things are not the...
2019-03-04
23 reads
system_health Extended Events in Azure SQL Database
The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management...
2019-03-04
500 reads
Watch: Kendra Breaks and Fixes SQL Source Control (9 minutes)
I love breaking technology. Well, I love breaking technology on purpose, in a place where it’s not going to slow anyone else down. It’s a great way to learn...
2019-03-04
13 reads
Weekly reading #5
Last week was busy the busy one. The SQL Bits, SQL Server CTP 2.3 and other great stuff have come...
2019-03-04
344 reads
Last Week Reading (2019-03-03)
Hey everyone! I was very busy at the SQLBits conference last week, but it did not stop me to prepare...
2019-03-03
310 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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