Q&A: Dealing with Thousands of Databases
This is part one of a three-part series. I’ve mentioned in various places, including in blog posts on occasion, that my production SQL Server instance hosts several thousand (nearly...
2019-09-03
341 reads
Blog Posts
Speaker at Music City Tech 2019
I’m very happy to announce that for the first time, I will be participating as speaker at the Music City Tech 2019 in Nashville. Here are the details of...
2019-09-03
27 reads
Techorama Netherlands 2019
You only have a few more weeks to sign up for one of my favorite events, Techorama. This year is the second time the event will be held in...
2019-09-03
14 reads
The 99 Flavours of SQL Server are all Vanilla
There are so many options for running SQL Server now. It can feel a little intimidating. You’ve spent years gaining experience with SQL running on Windows Server. On bare...
2019-09-03 (first published: 2019-08-22)
564 reads
Using Raw Files in SSIS
SQL Server Integration Services is well designed for retrieving and processing data on the fly, directly in the data flow pipeline. However, there are circumstances that occasionally require the...
2019-09-03
40 reads
Using strace inside a SQL Server Container
So, if you’ve been following my blog you know my love for internals. Well, I needed to find out exactly how something worked at the startup of a SQL...
2019-09-03
18 reads
Whitespace, Letter Case, and Other Things That Prevent Plan Reuse
Watch this week's video on YouTube
Last week's post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace.
In addition...
2019-09-03
10 reads
Whitespace, Letter Case, and Other Things That Prevent Plan Reuse
Watch this week's video on YouTube
Last week's post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace.
In addition...
2019-09-03
23 reads
20 Years of Redgate Software
Yeah, Redgate is only one year younger than my children. What’s really frightening is that I’ve been using Redgate’s products since my kids were a year old. I was...
2019-09-02
32 reads
Protected: Vajrasara – an interview with Lashana Lewis – Part 1
There is no excerpt because this is a protected post.
2019-09-02
20 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
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
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
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