I have a query which searches resords in two tables. I use the Left and Right functions and the query runs "Perfect". Problem comes when trying to save said query - I get an invalid argument when saving. Any ideas ???
How do organizations overcome max disk IO in Microsoft SQL? I come from a db2 background - I have never seen this issue before. Thanks again for your help.
Actually the machine has 1GB memory and the memory utilization is only at 30-35%. My real question is "Can you write a query and specify how much disk IO at a max will be used?"
I am running into difficulties when running any queries on 3 processor SQL 7.0 Server. All other users' access slows to a halt until query is complete. I checked processor utilization - it is less than 10% on each processor. Memory is only utilized to 35%. BUT - disk IO is maxed out. I am...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.