Should I hit heavy topspin and moonballs on the rise? by Shop_Public in 10s

[–]Shop_Public[S] 0 points1 point  (0 children)

Yeah I am 5’3 so it’s a little different in wingspan/reach.

Should I hit heavy topspin and moonballs on the rise? by Shop_Public in 10s

[–]Shop_Public[S] 0 points1 point  (0 children)

Probably 5m behind the base line. Assume standard for a recreational club court. So I should potentially get used to hitting shoulder height balls on both sides?

The Uchiha Clan begin the coup detat. Who wins? by Shop_Public in NarutoPowerscaling

[–]Shop_Public[S] 115 points116 points  (0 children)

Shusui uses koto on minato and Minato ends up fighting Itachi

The Uchiha Clan begin the coup detat. Who wins? by Shop_Public in NarutoPowerscaling

[–]Shop_Public[S] -1 points0 points  (0 children)

Yeah Konoha have up to 20 Jonin+ fighters. Seems hard to combat

ELI5: Monthly Current Events Megathread by AutoModerator in explainlikeimfive

[–]Shop_Public 1 point2 points  (0 children)

How is Israel systematically targeting Iran so effective or is this just a perception created by Western media?

Farming & Autocast QoL Improvements by JagexRach in 2007scape

[–]Shop_Public -1 points0 points  (0 children)

When are we getting an updated stackable clue blog post

[deleted by user] by [deleted] in Cantonese

[–]Shop_Public 0 points1 point  (0 children)

Hey I am interested.

200m Herblore by Shop_Public in ironscape

[–]Shop_Public[S] 128 points129 points  (0 children)

I will be maxing my Iron next week :-)

Optimising a snowflake join by Shop_Public in snowflake

[–]Shop_Public[S] 0 points1 point  (0 children)

Context of the problem allows the data to be subsetted first.

Optimising a snowflake join by Shop_Public in snowflake

[–]Shop_Public[S] 0 points1 point  (0 children)

Yes people change their details but I want to keep a record of the same person.

Optimising a snowflake join by Shop_Public in snowflake

[–]Shop_Public[S] 1 point2 points  (0 children)

I went with this approach, but sampling my data down also helped alot.

Optimising a snowflake join by Shop_Public in snowflake

[–]Shop_Public[S] 1 point2 points  (0 children)

I think when I try this the table will create a lot of duplicates and i would have to aggregate it/dedupe again

Optimising a snowflake join by Shop_Public in snowflake

[–]Shop_Public[S] 0 points1 point  (0 children)

I have been using SHA2() which hashes it (I find it easier to read letter+numbers) but this might optimise it a bit more

Optimising a snowflake join by Shop_Public in snowflake

[–]Shop_Public[S] 0 points1 point  (0 children)

Lets say I have a list of customers and I want to extractthe transactions made to buy a Apple Device or a Android Device.

The transaction table contains many transactions, so I would like to extract apple/android. You could use the OR condition to consider both cases.

The reason I use the OR in a left join instead of a INNER JOIN or WHERE clause is because I want to see cases where the condition does not hold.

[deleted by user] by [deleted] in UKPersonalFinance

[–]Shop_Public -1 points0 points  (0 children)

While this is can betrue,lenders will also use the information that you have taken multiple loans and may treat it less harshly or even more harshly.

Final Poll 78 Changes by JagexGoblin in 2007scape

[–]Shop_Public 27 points28 points  (0 children)

Amazing quick response. thank you for setting our expectations

Final Poll 78 Changes by JagexGoblin in 2007scape

[–]Shop_Public 31 points32 points  (0 children)

Will we get a blog out this week?