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 1 year, 8 months ago by frederico_fonseca.

https://learn.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-stop-operation-ssisdb-database?view=sql-server-ver16

requires SSIS_ADMIN - which grants why too much power and can allow a user to elevate itself to sysadmin

Thanks for your response - for sure it's encouraging .

following are the details

Table schema as follows :

Note : its Partitioned on column - Col_ID ( have to modify the...

on this case you don't need the third argument so just remove it (as well as the t2.ordinal from the select) and it should work as you intended.

you may need...

DROP TABLE if exists #testdata; 

--=============================
--Create test data table & Data
--=============================
CREATE TABLE #testdata
    
(
[freetext] varchar (200)NOT NULL,
)
;
insert into #testdata
select *
from (values ('abcd ksks -...

this is not a Postgres site - you better off asking here https://www.postgresql.org/community/

if it is a script you are generating from another system I advise you to do blocks of inserts each inserting a good chunk of rows using VALUES as per...

do also note that having CDC on the db means that those transactions will be kept on the LOG even if db is in simple recovery until they are processed...