2019 in Review
What an incredible year it’s been. I kept thinking that I was busy, but I had no idea until I looked at the final numbers (I have a Power...
2020-01-01
125 reads
SQL Homework – January 2020 – Document, document, document
Happy New Year! It being New Year’s, at least by the Gregorian calendar, I thought we could make this month’s ... Continue reading
2020-01-01
28 reads
Cannot Open Backup Device
When running into error 1326, it makes plenty of sense to try to create a backup dump device (only as a testing exercise) as well as test the connectivity...
2020-01-01
25 reads
Cannot Open Backup Device
When running into error 1326, it makes plenty of sense to try to create a backup dump device (only as a testing exercise) as well as test the connectivity...
2020-01-01
351 reads
2019 Year in Review
As we open 2020 (and the house is still quiet on this New Year’s Morning), I thought I’d take a moment to reflect on the past year.
Blogging 2019 was...
2020-01-01
15 reads
Negative Port Numbers
Validating your server setup is an integral component of your duties as a SQL Server DBA. When performing those validations, it is possible to run into an intriguing difference...
2019-12-31
128 reads
Negative Port Numbers
Validating your server setup is an integral component of your duties as a SQL Server DBA. When performing those validations, it is possible to run into an intriguing difference...
2019-12-31
768 reads
Happy New Year – Our Top Posts of 2019
With the New Year fast approaching and maybe already having arrived depending on where you are, we thought we’d do a quick recap of our top 5 posts from...
2019-12-31
31 reads
Last Week Reading (2019-12-29)
Hello boys & girls! This is the last post in “Last Week Reading” series in this decade. Can you believe that? Have you had a good Christmas time? Have...
2019-12-30
13 reads
Last Week Reading (2019-12-29)
Hello boys & girls! This is the last post in “Last Week Reading” series in this decade. Can you believe that? Have you had a good Christmas time? Have...
2019-12-30
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