yea, if dirty read is a big deal then you can't.

Have any triggers been added?

did you try the read uncommitted that I posted?

Well, look at the idea of a stored proc not needing to recompile everytime. If you are passing it different variables in each condition, we've had the best experiencing when...

Have you looked at global variables?

Have you completely eliminated the possibility of temp tables?

How about your tempdb size? Do you see anything in your logs about it growing pretty large?

Why...

I haven't done it in SQL Server 2005.

I would start here.

That link on that bottom takes you to the right place.

You're going to have to run ALTER DATABASE mssqlsystemresource

and the other commands there.

I can't speak about the distmdl or...

I'm sorry, I should have scrolled up to see that question was already answered. Long day yesterday.

Do you know if you are using Remote Collation?

is x64 involved at any point?

I see you are using php. I've used it just enough to be dangerous but is there a possibility about the connection to the database and a problem with localhost?

we had a variety of variables that could be there or not, so there would be conditions that determine the sp.

Simple example would be. There are more variables but that's...

Thanks...that got that part, but now I'm pulling my hair out on other issues related to this.

my response about our improvement wasn't relative to his specific example. I only stated that we had seen great improvement in our situation and it all involves testing.

are you using a hosting company who may have settings you aren't aware of?

I'm not sure I understand. Why are you looking in the registry?

Have you tried to find in the programs list?

What account do you have SQL Server and SQL Server Agent running under?