Viewing 15 posts - 45,406 through 45,420 (of 49,571 total)
At this point I would strongly suggest that you look at getting a second array for the log files. 2 drives mirrored should be adequate (though RAID 10 is the...
July 29, 2008 at 3:56 am
Why do you say that subqueries, outer joins and NULL checks are bad?
July 29, 2008 at 3:43 am
Will take a look tomorrow (if no one else solves it in the meantime, that is). Is past bed time here.
July 28, 2008 at 3:22 pm
Is this the same problem that was posted on the sqlserver.programing newsgroup?
July 28, 2008 at 3:04 pm
Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums.
No replies to this thread please. Direct replies to:
July 28, 2008 at 2:53 pm
The one case where I've seen a select take an X lock is inside a trigger if selecting from the table the trigger is on.
At this point, I'd suggest haul...
July 28, 2008 at 2:52 pm
Post reported.
Handing out brain dumps is a violation of the NDA that you take when writing an exam. It is illegal.
July 28, 2008 at 2:48 pm
There are two resources that I know of for learning to read exec plans.
Firstly there's Grant Fritchey's e-book. Last I saw it was available if you download any redgate product...
July 28, 2008 at 2:44 pm
Grant Fritchey (7/28/2008)
July 28, 2008 at 2:40 pm
Strange. The locks are IX or SIX (intent exclusive or select with intent exclusive). A simple select should just be taking an S lock.
Are these queries part of a stored...
July 28, 2008 at 2:38 pm
Post code?
Could it be blocking? If you query sysprocesses, what does it show for the 'hung' query? (specifically last wait type and blocked by)
July 28, 2008 at 2:34 pm
Please don't cross post. It just waste people's time and fragments replies. Many of us read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic542198-148-1.aspx
July 28, 2008 at 2:30 pm
Please don't cross post. It just waste people's time and fragments replies. Many of us read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic542198-148-1.aspx
July 28, 2008 at 2:27 pm
What do the following perfmon counters look like?
Physical disk Avg sec/read (break down for each disk)
Physical disk Avg sec/write (break down for each disk)
Physical disk reads/sec (break down for...
July 28, 2008 at 1:58 pm
That's far too long.
How big's the DB, how active and what is your storage system?
July 28, 2008 at 10:43 am
Viewing 15 posts - 45,406 through 45,420 (of 49,571 total)