don't know what tool you are using to execute the above -...

don't know what tool you are using to execute the above - but on...

Thanks for the feedback.

Jon,

This is a code deploy script file, I'm trying to create. Hence, need to set DB context first then run a few DDLs (see below)

Example snippet:

SELECT...

Cluster STXL on ( MANDT, TDOBJECT, TDNAME ) instead of creating all those separate non-clus indexes.  If those key columns are not inherently unique, and you can add a...

I'd like to run an SSIS package asynchronously from a SQL Agent job step through the the [SSISDB].[catalog].[create_execution] and [SSISDB].[catalog].[start_execution] stored procedures. I need the target package to be...

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

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