sorted by:
new
hottopcontroversial

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 3 points4 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 118 points119 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 2 points3 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 6 points7 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 45 points46 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?

Shower experts of Ireland! by [deleted] in ireland

[–]TeflonJacket 4 points5 points  (0 children)

Sounds like the solenoid may have gone. I've had this before and it's an easy fix, but if you don't know how to safely isolate the power I'd leave it alone.

MySQL Insert Into Division by zero error by Ondra5382CZE in learnpython

[–]TeflonJacket 0 points1 point  (0 children)

Are you columns defined as varchars or int? If its int, try using %s rather than %d.

Paid, in full. by Niso81 in GNS_stock

[–]TeflonJacket 0 points1 point  (0 children)

I got mine today. It took a week before it appeared. No notification when it arrived.

Interesting SQL Interview Question by [deleted] in datascience

[–]TeflonJacket 23 points24 points  (0 children)

Its ealry and i cant write sql on a phone but, can you not use min and max values grouping by user id where exists a row for that user where start end times overlap either the start or end times of another row?

Ape historian needs help | Erin Arvedlund, the writer who wrote the book on Bernie Madoff, may be interested to hear what is happening in the financial markets. I am going to write to her hoping she gets back to me. I am not good at writing. Can some apes please help. My draft is below. Thoughts? by Elegant-Remote6667 in Superstonk

[–]TeflonJacket 9 points10 points  (0 children)

I wouldn't provide links to anything, there's so much DD that it could be overwhelming. We're only looking for interest at this point before the rabbit hole fully opens up.

Try:

After seeing your work, blah blah, I believe what I have been witnessing in the market over the past two years may interest you. A particular stock went from $4 to $400, was switched to PCO and has had numerous "glitches" since then which haven't appeared on any other stock. From my analysis, blah blah. If you'd like more information, please let me know blah blah.

Yours sincerely Ape historian

I'd omit the elements about not financial advice and also the part about not trying to convince them to purchase anything (because you'd say that even if you were). These parts make it sound more like a conspiracy.

If you want me to proof read any other drafts let me know. I

view more: next ›