Ten Centuries,

"...Have you looked at indices and stats before changing the code?..."

No I have not done this.

I am not a big guru when it comes to TSQL performance tuning.

Can you tell how to do that and how to analyze that data?