and is the insert a single statement inserting single row values or is it the result of joining other tables - including the possibility of being done on a merge...

edit: dup post

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

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 1 years, 5 months 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 1 years, 6 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 -...