Resumable online index rebuild
continue on whats new SQL Server 2017 their is a great feature call resumable online index, means online index now has an option to PAUSE and RESUME or ABORT...
2019-11-04
151 reads
Deadlocks – Azure SQL Database
Would you like to troubleshoot a deadlock in Azure SQL Database? To do this you probably will be after the deadlock graph. So does this mean that you need...
2019-11-04
146 reads
Last Week Reading (2019-11-03)
This week I’m offering you many posts about Cosmos DB, Azure Data Factory and how to design reliable Azure applications. Have a great week also for those of you...
2019-11-03
17 reads
SQLSaturday Orlando Notes – Designated Hotel
Almost every year we select an “official” hotel for the event. For those coming in who don’t know the area it’s a way to avoid figuring out what is...
2019-11-03
23 reads
Why I’m Running For The PASS Board – Again
Hello, it’s amazing to me how fast the past couple of years have gone by as I’ve served on the PASS Board. It has been a journey that has...
2019-11-02
21 reads
Back to school
Hey, I realize that future we need to know Database system, No SQL and Big Data. with that as things are moving to machine learning and AI system which...
2019-11-02
27 reads
Why I Am Running for PASS Board of Directors
I am on the 2019 slate of candidates to run for the PASS Board of Directors, and am looking forward to the process, the opportunity, and the outcome.Regardless of...
2019-11-01
18 reads
My current VS Code Extensions and using a workspace file
I have been asked a couple of times recently what my Visual Studio Code extensions are at the moment so I thought I would write a quick post and...
2019-11-01
218 reads
Talk To Me At PASS Summit 2019
I say this all the time, but shockingly few people take advantage. Say hi to me. Please. I’m going to be at PASS Summit next week. I’ll be presenting...
2019-11-01
19 reads
Good Resume Examples
I talk about resumes, enhancing your career, and finding your dream job at various events. This might be one of my most popular talks, and I’ve been lucky enough...
2019-11-01
347 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