Recursively Querying Row Groups
Watch this week's video on YouTube
Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to...
2020-08-25
7 reads
Watch this week's video on YouTube
Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to...
2020-08-25
7 reads
Watch this week’s video on YouTube. Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values...
2020-08-10 (first published: 2020-07-29)
573 reads
Watch this week's video on YouTube
Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values for...
2020-07-29
8 reads
Watch this week's video on YouTube
Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values for...
2020-07-29
Watch this week’s video on YouTube. A Giant Heap Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don’t ask me why this...
2020-08-03 (first published: 2020-07-22)
282 reads
Watch this week's video on YouTube
A Giant Heap
Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don't ask me why this 3.5 billion...
2020-07-22
5 reads
Watch this week's video on YouTube
A Giant Heap
Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don't ask me why this 3.5 billion...
2020-07-22
2 reads
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven’t been any videos in a while. If you are...
2020-07-16
14 reads
Watch this week's video on YouTube
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven't been any videos in...
2020-07-16
6 reads
Watch this week's video on YouTube
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven't been any videos in...
2020-07-16
1 reads
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...
By Steve Jones
I can’t believe I’ve been at Redgate long enough to get a third sabbatical....
Comments posted to this topic are about the item How Many Can Be the...
Comments posted to this topic are about the item How to process images and...
Comments posted to this topic are about the item Patching the Patch
I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:
select GREATEST( col1, col2, col3, ...)See possible answers