Thanks for your replies. I noticed when I finally got to look at a few execution plans that there were quite a few Index scans going on that were not...

I do not at the moment unfortunately. I will have to restore my DB backup and try running a section of the script in isolation to generate one. How is...

Excellent, thanks, I look forward to going through it!

Excellent article, any time frame as to when part 2 will be available, I am just starting out trying to setup PPTR and need all the help I can get!...

Thanks for all your input, guess I have a lot of homework to do. I think I will setup a couple of labs and start practicing, may as well give...