I know that there are other ways to achieve a portion of my goal, with indexes, etc. I do NOT want to create any more indexes than I already have on this database, period. That is not an option.
I know that some of you actually think NOLOCK is an evil thing. I just want to know if it possible to set all SELECT statements at either the server scope or the database scope to automatically, by default, to use WITH (NOLOCK) hints. And, if so, how can I get to and change that setting?
If you don't know and just want to tell me that I should be doing this or that, I honestly appreciate it, but it doesn't help me achieve the task at hand.
Thanks again in advance. Someone out there HAS to know this one and be able to point me in the right direction. Opening all stored procedures and adding (NOLOCK) to every FROM and JOIN would be a multiple day task. I'm just trying to save myself some time as well as my company.
I wasn't trying to be snitty/snotty at all, what-so-ever. I was just trying to get my point across, nice and clear. That way, no one sent me down other avenues or paths that did not pertain to the question at hand. If I offended anyone for being direct and to the point, I apologize. I appreciate you getting back to me promptly and for the information that you gave me.
On the same note, you complained about me being "snitty", which I wasn't trying to be at all, but in return you are the same way to me? I completely understand where you're coming from, but if you are going to complain about someone's attitude, wouldn't it make more sense not to be that way back and be a hypocrite?
I honestly wasn't trying to be a jerk. I just wanted to be blunt, direct, and receive responses about the exact issue that I had in question. Thanks again for pointing me in the right direction. If anyone else has more information, I would appreciate it.