I’ve written about statistics in SQL Server a few times now. Through conversations I am reminded that not everyone keeps their table statistics up to date. Keeping your statistics...
2019-09-26 (first published: 2019-09-18)
505 reads
I am a SQL Administrator and today I will share my experience about an issue on SQL server, which corrupted the transaction logs and left the database in a...
2019-09-25 (first published: 2019-09-17)
2,956 reads
I had a discussion a while back, I think it was with Grant Fritchey (b/t) but I just can’t remember. ... Continue reading
2019-09-25
26 reads
In my final post about gatekeeping in technology, I have to come clean about something. Let’s go through this journey together. In the first post we spoke about what...
2019-09-25
19 reads
An amazing blog post by Microsoft describing the idea of hot patching the database engine in Azure SQL Database to allow for minimal downtime when applying patches to SQL...
2019-09-25
37 reads
I’m going to lose today again. This time I’m headed back to Australia and in flight. I wonder if I’ll get used to this, as I expect between work...
2019-09-25
23 reads
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on Github. This dockerfile was under the mssql-server-linux-non-root directory and (you guessed it) allows SQL Server...
2019-09-25 (first published: 2019-09-18)
1,000 reads
Do you frequently use the “log_reuse_wait_type_desc” column in the [crayon-5f297eff3d7ff981952735-i/] view? Have you ever seen the type of OLDEST_PAGE? You are not the only one!! Recently I was troubleshooting...
2019-09-24
1,528 reads
At a project, we asked if we could get a SQL Server login/user so we could make a connection from an Apache Airflow pipeline to the SQL Server instance....
2019-09-24
326 reads
At a project, we asked if we could get a SQL Server login/user so we could make a connection from an Apache Airflow pipeline to the SQL Server instance....
2019-09-24
15 reads
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
By Steve Jones
This month we have a new host, which I am grateful for. So many...
I needed to do some research because there is more to #temp tables than...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
Comments posted to this topic are about the item 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