What’s In My Utility Belt? Issue #2
Wow, can you believe it’s been a month already since I posted the first issue of “What’s In My Utility...
2013-11-30
1,105 reads
Blog Posts
Digging Around For Free Tools – SQL Server
Tool Archaeology, Digging Through The Web
About every three to six months I will burn some time and just go digging...
2013-11-29
1,360 reads
Digging Around For Free Tools – SQL Server
Tool Archaeology, Digging Through The Web About every three to six months I will burn some time and just go digging for tools. Mostly, I’m looking for stuff related...
2013-11-29
15 reads
Free Friday: Training
There are a number of good sites that offer free training and free E-Books. The community around MS SQL is...
2013-11-29
1,191 reads
Friday Followup For November 29, 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-29
1,001 reads
How to Fail a Phone Screen
It’s funny to me how easy it is to fail a phone screen – both as the interviewer, and as the...
2013-11-29 (first published: 2013-11-18)
4,159 reads
Reblog: November 22 to November 28
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-29
1,399 reads
How to reset the SA password in SQL Server
Getting locked out of a SQL Server can happen in a number of ways. You could inherit a server that...
2013-11-28 (first published: 2013-11-21)
6,607 reads
Power BI for Office 365 video
A demonstration of Power BI for Office 365, showing you how all the various tools and technologies work together: Power...
2013-11-28 (first published: 2013-11-21)
2,068 reads
Throwback Thursday #2: Get Your Speak On!
I hope everyone is having a great Thanksgiving with their families. When you come out of that food coma I...
2013-11-28
1,109 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