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 years, 6 months ago by frederico_fonseca.

the issue with trying this at a DB level is that you are not proving anything - if the OS/VM/Storage is badly configured then ALL the IO is going to...

Jeff will no doubt add something here - do heed his advise.

but as mentioned (and as you yourself raised as an issue) partitioning should only be used when most of...

one one of your other posts you mentioned that your VM's were Vmware - AWS and AZURE are a totally different kettle of fish and settings for those are way...