I have a job running in SQL Server 2000. I have defined triggers on some tables. I have used LTRIMs and RTRIMs in my triggers.
Now, there is a performance issue in my job. Its taking a lot amount of time for successful completion.
I have been suggested to trim the data while inserting or updating in the base tables rather than doing the same in my triggers.
The load procedures in my base tables is very simple. It simply pulls incremental data from a source database (also in SQL Server 2000).
My concern is, will transferring the LTRIM RTRIM functions from the triggers to the Load Procedures of the base tables improve the performance of my job?
Thanks in advance.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!