Requirement: Remove a node from one of...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-07-17
126 reads
We love xp_fixeddrives here, it’s a quick and simple way to see how much space you’ve got available on your drives. But there are just a couple of things...
2019-07-17 (first published: 2019-07-03)
832 reads
While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis...
2019-07-17
38 reads
This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or...
2019-07-17
38 reads
This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or...
2019-07-17
15 reads
This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or...
2019-07-17
6 reads
[read this post on Mr. Fox SQL blog] The “modern data platform” architecture is becoming more and more popular as organisations shift towards identifying, collecting and centralising their data...
2019-07-16
22 reads
I’m excited that the Redgate Foundry is working on some cool projects. The Future of DevOps is one and part of that work is with Spawn. I’ve played with...
2019-07-16 (first published: 2019-07-01)
452 reads
Watch this week's video on YouTube
In order to stay current in a technology you have to immerse yourself in community content.
Documentation is good for knowing the specification of a...
2019-07-16
7 reads
Watch this week's video on YouTube
In order to stay current in a technology you have to immerse yourself in community content.
Documentation is good for knowing the specification of a...
2019-07-16
12 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...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
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