« first day (3821 days earlier)      last day (34 days later) » 

6:06 AM
Morning
 
 
1 hour later…
7:31 AM
Morning
 
morning
 
A chairde - Morning all! @ypercubeᵀᴹ - looks like EB has cast some light on our issue - but his answer doens't really chime with my tests... I'm going to double-check and reply to his comment under my answer...
 
7:50 AM
@Vérace You could also ask a question of your own if there is some specific issue you want clarity on?
 
Am considering that option also... might be too big for a comment!
 
8:06 AM
@Vérace Erwin's answer has:
> Your 1st (fast) query plan shows 2x Parallel Seq Scan and 1x Parallel Index Only Scan.
Your 2nd (slow) query plan has no parallel queries. Damage done.
23 hours ago, by ypercubeᵀᴹ
@Vérace you can add to your answer that one difference between the 2 plans provided (what I can see, I may have missed something else) is that the first (faster) one has Parallel Seq Scan on xformula xformula_1 while the 2nd has Seq Scan on xformula xformula_1.
@Vérace did you manage to get a parallel plan in your tests, while using a function?
 
8:31 AM
@ypercubeᵀᴹ - yes, you were on the money... but the MATERIALIZED directive still makes a difference... I'm finishing my breakfast - will look at this presently - don't want to cross swords with EB without having my homework done! :-) Luckily, my home machine is multi-processor and I was getting parallel plans without functions and the function blocked that - so that's one I can test... I'll keep you posted here when I respond to EB!
 
> but the MATERIALIZED directive still makes a difference
did EB say otherwise?
 
9:26 AM
Quick one: How does one determine what version of SQL OLE DB are installed on a system?
In MDAC there used to be a tool that would scan the system and return the versions of the installed components.
My Google-fu is failing me
Might be one for @Lamak:
1
Q: SQL Dynamic Query based on user input in PowerBI

Felix SilvaI am pulling data from inSQL using the SQL Query below: SET QUOTED_IDENTIFIER OFF SELECT * FROM OPENQUERY(INSQL, "SELECT DateTime, [X],[Y], [Z], [A] FROM WideHistory WHERE wwRetrievalMode = 'Cyclic' AND wwResolution = 1000 AND wwVersion = 'Latest' AND DateTime >= '20210601 20:02:33.000' AN...

 
@JohnK.N. odbcad32.exe
Drivers tab
 
9:43 AM
That's just for ODBC drives and doesn't display OLE DB.
 
@JohnK.N. Maybe this.
 
9:58 AM
Thanks.
 
 
10 hours later…
7:34 PM
Morning
 
7:50 PM
Morning
 

« first day (3821 days earlier)      last day (34 days later) »