Superpowers Revealed
Like many of you out there, I’m constantly looking for new things to learn. A new skill, a new hobby,...
2013-11-16
417 reads
Blog Posts
A Tour of the Transaction Log: Part 3 Reading Log Backups
In part one and two of our Tour of the Transaction Log articles we focused on reading events from the...
2013-11-15
1,475 reads
Checking your users and groups in Command Window.
As a DBA, I work closely with the Infra guys to manage domain accounts. Now and then, there comes a...
2013-11-15
524 reads
Fill Factor, Why Do You Taunt Me? Part 1
Like all the arbitrary numbers we hear in the SQL community such as the 30% fragmentation and 1000 pages. These...
2013-11-15
746 reads
Friday Followup For November 15, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-15
482 reads
Reblog: November 8 to November 14
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-15
757 reads
SQL Server Diagnostic Information Queries for November 2013
I have made a number updates and bug fixes, including some additional columns in some of the queries for all...
2013-11-15
1,158 reads
SSRS Map Layers Parameter
With the new Map control in SSRS 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If...
2013-11-15 (first published: 2013-11-11)
1,505 reads
The Failed Job
I was looking into a failed job on a SQL Server 2008R2 instance. My first step was to check the...
2013-11-15 (first published: 2013-11-07)
1,671 reads
Use application lock to synchronize T-SQL code
Application lock can be used to synchronize T-SQL code, you can control if the session is able to run the...
2013-11-15
5,055 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