Hello, I confirm that changing the transaction of batch task from none to before task prefix solves the multiple connection issues. now we have to check our application logic to see if all these trans

#performance #mssql #xpa

Yes, definitely stored procedure. Direct SQL should be used only if you don't have a better approach. With direct sql there is an additional issue of transaction processing related to Magic/xpa. It is

#mssql

Thank you Steven Burrows! To be honest i would love to completely remove the incremental search ... But sadly we cannot live without it. Its a "must" feature. I turned on logging to see exactly what i

#mssql