• Thank you Sean, I know it might be a lot of work looking at it in depth (when is not really your job).

    About the NOLOCKs they were there when I got here and considered as a good practice in here, but after reading some articles you've posted in other topics I'm trying to change this (they're off my query now).

    However, my question about the columns was if it made a significant difference if I took the information directly from the table (which is in another database) instead of taking them from the view (based on the views, based on the original tables). I'm making the test right now.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2