Viewing 15 posts - 151 through 165 (of 226 total)
yea, if dirty read is a big deal then you can't.
Have any triggers been added?
September 24, 2008 at 9:54 am
did you try the read uncommitted that I posted?
September 24, 2008 at 9:41 am
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...
September 24, 2008 at 6:10 am
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...
September 23, 2008 at 1:08 pm
I haven't done it in SQL Server 2005.
I would start here.
September 23, 2008 at 9:21 am
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...
September 23, 2008 at 8:22 am
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?
September 23, 2008 at 8:13 am
is x64 involved at any point?
September 23, 2008 at 8:03 am
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?
September 23, 2008 at 7:07 am
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...
September 23, 2008 at 7:05 am
Thanks...that got that part, but now I'm pulling my hair out on other issues related to this.
September 22, 2008 at 8:13 pm
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.
September 22, 2008 at 6:33 pm
are you using a hosting company who may have settings you aren't aware of?
September 22, 2008 at 6:02 pm
I'm not sure I understand. Why are you looking in the registry?
Have you tried to find in the programs list?
September 22, 2008 at 5:55 pm
What account do you have SQL Server and SQL Server Agent running under?
September 22, 2008 at 5:54 pm
Viewing 15 posts - 151 through 165 (of 226 total)