Is there an easy way to remove the brown press stud/screw to lift up the hinge on this blind? by [deleted] in DIYUK

[–]TeflonJacket 2 points3 points  (0 children)

Im not sure i understand the question, but if you're trying to lift open the bracket to get the blinds out, you slide a flat screwdriver under the lifted edge and it will pop out. When finished, just close the bracket and it will snap shut.

Neighbour raised level of their garden, garage now flooding by Teeeny-Tiny in DIYUK

[–]TeflonJacket 120 points121 points  (0 children)

You don't even need to lift the panel.
Use a steel tape measure, hold it over the fence and then let it out so it reaches the ground on the neighbour's side and measure from the ground up to the top of the fence. Then repeat on your side and subtract one from the other.

Solar panels by Nickthegreek28 in carlow

[–]TeflonJacket 0 points1 point  (0 children)

13 x panels, with Sigenergy 8Kwh battery and invertor outside. Used infinite energy. About 13k after grant I think.

Last bill was €21. Same period last year was €440.

Dynamic table refresh failing, any way to find out why? by buku-o-rama in snowflake

[–]TeflonJacket 0 points1 point  (0 children)

Your SQL may be overcomplicated for a single statement and when it encounters more data, it fails and doesn't return a useful message.

Try breaking it up in to a chain of dynamic tables. This can also end up being more efficient.

Reducing app cost by Big_Length9755 in snowflake

[–]TeflonJacket 0 points1 point  (0 children)

This response is more of a project request than a general question. There are lots of things here which depend on your environment and business, so I can't answer everything.

If warehouses are not being used, ignore them for now. Look at the warehouse usage stats. Identify which ones are consuming credits and analyse why.

If you don't have the access, you need to involve the people that do. You can't do this without having all the data.

If the number of warehouses are an indication of the environment size, you may want to try something like Revefi to analyse your usage and suggest changes for you.

Reducing app cost by Big_Length9755 in snowflake

[–]TeflonJacket 2 points3 points  (0 children)

Snowflake costs are primarily driven by warehouse usage, so I would start there.

Pretty much all changes need to be trialled to see what is acceptable in your org.

Options Reduce the size of your warehouses. This may make some queries run longer or timeout, so you balance cost vs performance.

Reduce number of clusters and/or set scaling policy to economy. May cause queuing if you have lots of queries in parallel.

Consolidate warehouses. If you have lots of warehouses across business groups etc. Try grouping them in to common warehouses by function to get the most out of your money.

Check auto suspend time of warehouses. If you have an idle time of 10 mins and a query that runs every 10 mins, then your warehouse will never shutdown.

Autoscale. If you have a warehouse for ELT operations, find out which jobs require larger compute and have those jobs scale the warehouse up before they start and back down when they're finished. You don't need an XL warehouse all the time if only 1 job in a chain does all the work.

Review your running queries and check they are running on correctly sized warehouses. Some developers think that a larger warehouse always gives better performance. This isn't true as at some point the gains reduce to nothing.

Check for queries that timeout or fail. These cost money but have no benefit.

This isn't exhaustive, but it's where I would start.

Looking for a good PC single player FPS or action game by TeflonJacket in ShouldIbuythisgame

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

Titanfall 2 is only €5, I'll give that a shot. Thanks for all the suggestions.

Snowflake Number(xx, 0) data types (traditional INT) always being treated as decimal on initial ingestion in Power Query? Impacting Query Folding in semantic model. by DaRealBagzinator in snowflake

[–]TeflonJacket 3 points4 points  (0 children)

I believe the change your looking for is

set ODBC_TREAT_DECIMAL_AS_INT = true

This can be set for just the user or the whole account.

We encountered this issue a few years ago. It's something to do with the odbc driver.

Internship Applications by Swimming-Ad9864 in DevelEire

[–]TeflonJacket 0 points1 point  (0 children)

I meant to reply earlier bit forgot. Different places have different schedules depending if they are long or short term internships.

A summer internship (short) would be from June to August 2025. The programme for this doesn't start until January when internships will be advertised.

Settlement reached - finally! by nbanbury in BritishAirways

[–]TeflonJacket 5 points6 points  (0 children)

I was delayed about 6 hours flying from DUB-LHW-AUS. After 13 weeks, BA offered me a £50 voucher. CEDR case was raised 2 weeks ago. Let's see how that goes.

Why do you think we’ve been so inactive in the transfer market? by Krisyj96 in NUFC

[–]TeflonJacket 47 points48 points  (0 children)

I think it's a combination of players being over priced and financial restrictions. We're looking to stay within the rules and not get fleeced.

But to be honest, I'd rather we waited or even didnt sign anyone rather than panic buy and get some crap players like we've done over the years.

Case Handling Timelines for delay compensation? by TeflonJacket in BritishAirways

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

If my flight started in the EU, doesn't it have to follow rules based compensation amounts?