Moving 1/3 of a heap
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
18 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
18 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
19 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
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
4 reads
Watch this week’s video on YouTube. This week, I want to share my process for analyzing Twitter. Specifically, I want to find who all of my friends follow on...
2020-01-14 (first published: 2020-01-07)
300 reads
Watch this week's video on YouTube
This week, I want to share my process for analyzing Twitter. Specifically, I want to find who all of my friends follow on Twitter...
2020-01-07
21 reads
Watch this week's video on YouTube
This week, I want to share my process for analyzing Twitter. Specifically, I want to find who all of my friends follow on Twitter...
2020-01-07
9 reads
Watch this week’s episode on YouTube. Pop quiz: What will be the output of the below three statements? As you might have guessed, the first conversion truncates the value,...
2019-12-17
231 reads
Watch this week's video on YouTube
Pop quiz: What will be the output of the below three statements?
DECLARE @val_varchar varchar(3) = '100';
DECLARE @val_bigint bigint = 100;
DECLARE @val_tinyint tinyint = 100;
PRINT('varchar...
2019-12-17
10 reads
Watch this week's video on YouTube
Pop quiz: What will be the output of the below three statements?
DECLARE @val_varchar varchar(3) = '100';
DECLARE @val_bigint bigint = 100;
DECLARE @val_tinyint tinyint = 100;
PRINT('varchar...
2019-12-17
12 reads
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
hi , our business partner is asking s4 sap api's for receivable info and...
I have a really stupid question... Is there an easy way to search for...
Comments posted to this topic are about the item How to Work with On-Premises...
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers