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, 7 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...

I would try and break it down into 2 (maybe 3) sql blocks by moving some of the "good plan joins" - those which have INNER joins - to a...

it can be answered - but its a tricky (misleading) question as it is trying to divert the question to a particular aspect, while the important point is another.

well... what Phil posted will remove the message - but the other way you may be using the isnull will not

so if you do the alternative to Phil's. where you...

and it takes 100 seconds to return 5.5 million rows TO WHAT CLIENT?? - if SSMS then the issue is likely not the query, neither the server but the simple...

the correct answer always works correctly - and it is...