DBA in Space: Behind the Scenes—Questions 2 & 3
Part 1 of Question 2—The question.Part 2 of Question 2—The follow up to the question.This is a continuation of my...
2011-11-21
645 reads
Part 1 of Question 2—The question.Part 2 of Question 2—The follow up to the question.This is a continuation of my...
2011-11-21
645 reads
This is a continuation of my DBA in Space journal.
In the opening of the first episode of DBA in Space,...
2011-11-18
640 reads
This is a continuation of my DBA in Space journal.
In this next series of blog posts, I am going to...
2011-11-17
684 reads
This is a continuation of my DBA in Space journal.
Friday, September 16, 2011
OMG. (This is the first time in my...
2011-11-16
615 reads
This is a continuation of my DBA in Space journal.
Monday & Tuesday, September 12-13, 2011
Today I make my “secret” journey to...
2011-11-15
560 reads
The DBA in Space contest ends November 18, 2011. If you haven’t entered yet, you still have time.
Filming DBA in...
2011-11-14
728 reads
In SQL Server 2005 and later, there is a database option called “forced parameterization”. When it is turned on, it...
2011-11-14
796 reads
(I’m ‘standing in for Brad, who is busy ..er.. somewhere, and I found this unpublished piece by Brad and I....
2011-11-03
1,424 reads
Selecting which hardware to run SQL Server on is often discussed among DBAs. So, for this month’s question, “What is...
2011-11-01
504 reads
Today we have a guest post from Steve Jones.
I survived SQL in the City in LA, and thanks to everyone...
2011-10-31
1,556 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
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