Hi Scott, right now your functions are in production to be tested. At the moment there were no improvements in response times but the percentage of CPU is the lowest...

This is a actual execution plan, i take all the code and comment all union lines. I change the extension of .sql to .txt for upload

Hi MVDBA, yes i use a split function. Normally not wold take more than 10 splitted ID.

Also i was take all the code and run real execution plan and create...

We have a sql job that reorganizes / rebuilds the indexes every day. This same JOB also updates the statistics of the tables with fragmentation greater than 10. I will...

I'm sorry, it seems it was a upload error