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 9 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 9 months, 1 week 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...

but do investigate all performance issues with 2022 before upgrading - many reporting 20 to 40% slower queries.

SQL 2022 will give you batch mode execution plans on indexes that are not columnstore, even if batch mode execution plans are slower.

Did you look at the execution...

VS2022 is (or has) a 64 bit version - this is a first - all prior versions were 32bit. so you need to check what version you did install (64...

• This reply was modified 9 months, 3 weeks ago by  frederico_fonseca.