In this article we are going to look at some guidelines and MSDTC best practices with an Availability Group. Please note that some of these recommendations change if you...
2019-10-23 (first published: 2019-10-14)
502 reads
If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause because of your use of it when manipulating data with DELETE and UPDATE statements. It’s...
2019-10-21 (first published: 2019-10-14)
617 reads
I don’t know about you, but I like having the tools that I’m likely to use on my taskbar. That ... Continue reading
2019-10-14
95 reads
Years ago Redgate Software started some work to link our tools together. I remember early efforts, about which I had dubious thoughts as to the value. I hadn’t looked...
2019-10-21 (first published: 2019-10-14)
268 reads
The first of our new series of new look podcasts, David has a look at intent locks in SQL Server and what the purpose of them is.
2019-10-18 (first published: 2019-10-14)
202 reads
I have been working a lot of SQL Graph related queries and applications of the graph data concept to the extent possible within SQL Server’s graph capabilities. Genealogy, or...
2019-10-17 (first published: 2019-10-14)
1,198 reads
This is my second post in a series which I hope will help you (and me!) prepare for the upcoming PASS Summit November 4-8, 2019 in Seattle, Washington.
Networking, Networking!...
2019-10-14
9 reads
It’s just a couple weeks until the SQL in the City Summit comes back to London. This is our second Summit this year in London, and I’m honored to...
2019-10-17 (first published: 2019-10-11)
218 reads
Certified Microsoft Azure Fundamentals - AZ-900 1 day Web based Course - 12th December 2019
Its been a big few of weeks here at gethynellis.com. We've been accepted onto the UK...
2019-10-11
5 reads
Certified Microsoft Azure Fundamentals - AZ-900 1 day Web based Course - 12th December 2019
Its been a big few of weeks here at gethynellis.com. We've been accepted onto the UK...
2019-10-16 (first published: 2019-10-11)
365 reads
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Hub Via Wa:628218154374 Alamat Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung,...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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