I have a huge insert/update operation performing in set of tables. The process tooks almost 1-2 hours to complete. Meanwhile tempdb is growing fast and most of my applications using the sql server gets hung during that time.
To overcome this Replacing the stored procedure with SSIS will help in my scenario???
Please share your valuable inputs. Thanks in advance!