give us the actual explain plan so we can look at it - images do not help us identify potential issues.

sure you can - ask a good developer on your company to do it

and you can always try it yourself by googling and trying/testing/adapting the many many examples you can...

the registry setting you changed applies to SSAS queries - so it would never work for what you wish.

and it seems that this functionality was broken starting with v18 -...

Thanks

Steve for the Json references, Phil for the validation, Frederico for the date suggestion.

My workaround is storing it in an nvarchar(max) variable, replace the wanted character and write it...

but this being JSON why not use a date format that is more standard (ISO8601).

any software reading the file will most likely parse the value correctly, and you won't...

you have already been advised in your other threads around this process to review how its done and scrap it - you are keeping a wrong approach to a problem...

Product name is not required. - however if it is supplied through the UI as "SQL Server" the other fields (@provider, @datasrc, @location, @provstr, and @catalog ) don't need to...

you mean which one of these?

• using xp_cmdshell from a stored proc
• or use a SQL Job with a sqlcmd step
• or just use sqlcmd on the command line

and when...

thats an invalid format file for what you need.

see  https://jahaines.blogspot.com/2009/10/exporting-binary-files-to-file-system.html for a full example of what you can do - and you should likely reconsider using bcp for this -...

yes tempdb has been subject to significant changes. majority were done with 2016 - see https://learn.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database?view=sql-server-ver16

you will likely need the CU+GDR version - https://support.microsoft.com/en-us/topic/kb5029376-description-of-the-security-update-for-sql-server-2017-cu31-october-10-2023-ce23ddf7-b79e-4ba7-ba9d-2679f23a1ad8

Thank you,  I ran blitz and also installed sp_whoisactive (nifty tool).

I have GDR 14.0.2052.1 - do I need a CU as well?  Does the Query Store affect performance -...

SSRS (And power bi report server is a superset of this) is a licensed feature - as such it requires the server it is installed on to have a valid...

Thank you for your excellent directions - I should have read it more closely:-)  I've run them on the 2017 box.  Should I run it on the 2008 box...

did you run the cmd file that I supplied with the 3 commands on it? your reply does not indicate you did it as I asked.

or maybe you did run...

• This reply was modified 1 year, 4 months ago by frederico_fonseca.