that was a very important aspect to omit.

try this - without the current explain plan its impossible to know if it will help

WITH MaxD AS (select t1.*...

having explain plan would be the best thing for us to help - there are a few things on your query that don't look right.

-- original query...

issue is connectivity between your SQL server and your AD domain controllers , and potentially a few more network issues.

when using Windows Authentication the Server needs to validate with a...

a few other things will affect performance of delete.

does it have triggers

does it have links to other tables (and is cascade delete enabled) e.g. is part of a parent/child foreign...

19, 0 not enough as the data being truncated has at least 2 decimal places according to the error.

to the OP - if you don't know what the size should...

you can't - and a better option would likely be for  you to start using VS database projects and keep all your objects on it - easy to integrate with...

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

and what have you found in google? lots of hits including some in this site

its not the it corrupts - but if when running a package the user unsets a required parameter it may be defaulting to what is "hardcoded" on the package -...

have a look at attached spreadsheet - it is what I use to setup my servers.

on your case you will need to manually ensure that the SSAS memory does not...

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

lots of info on google - here is one https://www.progress.com/tutorials/odbc/connect-to-postgresql-database-from-sql-server-linked-server

you been advised to do process clear before process full - you still not doing it based on  your last script.

you rmemory (tabular) likely not set correctly either - as...

likely you need "set nocount on" at the top of your SP (it should be in ALL of them really)

SSIS is a licensed software (SQL Server license) - so in order to install it you will need to pay for its license.

you can install SSIS - but it will...

  And I know from just a tiny bit of experience that uploading a large number of records from oracle thru a linked server takes a lot of time. ...

not enough memory - a 4.5GB tabular cube is not that small - would equate to a 45 GB dimensional one.

you also likely doing a process default - this requires...