Forum Replies Created

Viewing 15 posts - 601 through 615 (of 7,506 total)

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data and code to get the best help

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Who am I ? Sometimes this is me but most of the time this is me

  • Reply To: Performance of same query slower for a different user

    Replace the Scalar Value function with a (in-line) Table Value Function and you will have a stable running potentially fast query !

    ...
    outer apply dbo.tvf_GenerateCostCode(CC.Code, SU.Code,...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • Viewing 15 posts - 601 through 615 (of 7,506 total)