looks...

that link kind of says it all - but it is a bit over the top in my opinion.

first thing - separate the 3 permissions mentioned (SHOWPLAN, ALTER TRACE and...

before worrying about how much you are going to need you should be looking at what tables did grow, and why - is that expected business data being added or...

how have you managed to max the VM in terms of storage?  unless you have a crap vm (which by the looks of it isn't, as a 32 vcpu is...

as mentioned on this, and other of your threads, the index usage gets reset with every restart/failover of the server (and likely also as part of a specific db restore/offline...

• This reply was modified 5 months, 1 week ago by  frederico_fonseca.

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 5 months, 2 weeks 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...