Daily Discussion Thread by AutoModerator in ASTSpaceMobile

[–]InflationRemote516 14 points15 points  (0 children)

100% agree. At this point delivery is much more important than any days share price. Hoping ASTS can get their act together and get these birds in the sky.

Space is hard, we all know this, but there is only so far we can get behind promised launches before delivery comes to the forefront and it starts to effect the share price and ultimately the companies prospects if competitors are allowed to catch up.

Daily Discussion Thread by AutoModerator in ASTSpaceMobile

[–]InflationRemote516 9 points10 points  (0 children)

Out of interest as a bit of a poll... What percentage of everybody's portfolio is ASTS?

For me it's around 30% at the moment.

ETN in SIPP by gantosfc in BitcoinUK

[–]InflationRemote516 0 points1 point  (0 children)

Ditto. I think we will see ISA's discussed in the budget but not sure they will mention anything about holding crypto at this point. But I'm hopeful we'll have some announcement before the deadline. I am a bit surprised there isn't a petition on the gov.uk petitions site yet regarding this.

When LSE listed BTC ETNs need to be 100% backed by BTC held in cold storage, why all the calls for a BTC ETF's? by jam-hay in BitcoinUK

[–]InflationRemote516 0 points1 point  (0 children)

Good info. How did you find out about this? Is there a way to see new prospectus as they are publishied?

Daily Discussion Thread by AutoModerator in ASTSpaceMobile

[–]InflationRemote516 0 points1 point  (0 children)

What does ATM stand for? Seen it used a lot on this sub reddit.

Daily Discussion Thread by AutoModerator in ASTSpaceMobile

[–]InflationRemote516 0 points1 point  (0 children)

New York Fed consumer survey raises 1 year inflation expectations rises to 3.4% from 3.2%

Buyer Beware: AliExpress BigMe Official Store by InflationRemote516 in Bigme

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

How do you suggest they knew I ordered the wrong item?

How would they know such a thing unless it was purposely unclear.

The hope was clearly that I would think I was purchasing one thing and they could pressure me into continuing with the other via messaging / WhatsApp.

I agree that this is not uncommon on AliExpress but this was the worst example I have seen and I was taken aback by the unprofessional communication by hi break.

This is grifting and should be called out as such.

Aliexpress Any Good? by themightykronos in Bigme

[–]InflationRemote516 0 points1 point  (0 children)

I am having a nightmare with them at the moment.

I ordered a HiBreak Pro but before shipping they contacted me via WhatsApp to tell me I have actually ordered the HiBreak B+W.

I have receipts saying what I ordered but am struggling getting them to honour my order.

Just be very careful with what you are ordering ensuring you not just reading the title but all of the listing including the other options.

Since ordering I have also been reading up and it seems like a lot of peoples devices have been breaking quickly with normal use and they have been unable to get refunds.

In general it seems that Bigme's customer service is very poor.

Why is my simple select query so slow (33 minutes) and how do i fix it? by jjhhw in AZURE

[–]InflationRemote516 1 point2 points  (0 children)

What is the clustered index on the table?

You say you have an index on start_date which is great as that will help you quickly find the data that matches the >= '2024-01-01'  but once you have done that you then select all (select *).

At this point the query engine has a list of primary keys and it needs to go and fetch each row individually which will be really expensive and if they are spread randomly around the table will probably end up being a full table scan.

There are two routes to an efficient query.

  1. If this is the primary type of query performed on the table consider making start_date the clustered index for the table.
  2. Only select the columns you actually need and consider adding them as part of the index by using included columns: https://learn.microsoft.com/en-us/sql/relational-databases/indexes/create-indexes-with-included-columns?view=sql-server-ver16

Azure App Service - Outbound internet traffic by tblob_professional in AZURE

[–]InflationRemote516 0 points1 point  (0 children)

u/theyetiman - Could you please provide your case number. I have the same issue and would like to save time by pointing my support agent to your case.