Tom V

<3

> [ECOWEBBSP].[ECOSYS].[TS_STRUKTUR].[<IndexAusExecutionPlan, sysname,>]

Happy new year

I skimmed the last messages, didn't look closely enough

blushes

morning

@ErikDarling I call it carb loading

@ErikDarling at least Zürich is a nice airport

Today I learned the new Zealand basketball team is nicknamed the "tall blacks"

all is well now

we rewrote the queries to only fetch what they need and removed the TVF

@ypercubeᵀᴹ for your information, we ended up rewriting the table valued function. Turned out he created a TVF joining everything because of reusability and then selecting subsets from it in separate queries only needing small parts of it

@ypercubeᵀᴹ not yet. I decided not to touch it until the original dev returns from vacation

no

can I force a plan to be recalculated?

pgplsql

can I do smoething like "recompile" like I would on a sql sproc?

is there something like a plan cache/plan reuse?

but I can imagine the plan varying a lot by input

@ypercubeᵀᴹ Running postgres, a table valued function seems to have very fluctuating performance

@ypercubeᵀᴹ are you around?

nant.sourceforge.net/release/0.85/help/tasks/script.html

ant.apache.org/manual/Tasks/script.html

Not sure about nant but that would work in ant

@CadeRoux on mobile now but can't you use a scriptdef and a JavaScript snippet in your build script?

@Lamak And @JohnK.N. thanks. It seems to be gen 2 and I am able to get a token to use for the rest of the API now. Somehow Microsoft managed to make the v2 docs useless compared to the v1 docs

can't find an obvious way to do it with azure storage explorer

Anybody familiar with Azure Data Lake authentication? I'm looking for a way to browse an azure data lake using only the client id, tenant and and secret

Hey

Fixed minor typo

Morning

@HannahVernon Link?

Made me quit the line of work. But I dealt with it exclusively

@MichaelGreen yep 365 was the final straw for me

@JohnK.N. fine. Busy with mostly non database related stuff

Sigh

Just got an upvote on an old answer and thought 'oh that's a nice answer' just to notice the good part was an edit by @billinkc

And it's a decent place so there aren't many interventions needed but still I would not be offended if you all picked someone else in this time zone to watch in case issues arise

Even though I love you guys life happens and I don't give you enough attention to properly watch the room

The job I got a few years ago moved me out of database administration and at the same time drawn my attention elsewhere

I totally would not be offended if my privilege were to be revoked and handed to somebody else

I think other people would be better suited to carry the room owner privilege at this point

Hey all. I've been thinking about this for a while. I'm barely active in this room and only visit every few days.

anybody happen to be familiar with influxdb?

@JohnK.N. TIHI

Merry Christmas

And definitely not be the subject of it

In any case I didn't want to cause any drama

@PaulWhite ikr

@PaulWhite did you remove it?