Viewing 15 posts - 46 through 60 (of 178 total)
As previously stated i'm not a big fan of books, not necessarily due to their inaccuracies at times or because i know that subject well enough to not have to...
August 8, 2011 at 1:06 am
is it exactly 3GB? Have you restarted the service since changing the size of the log file?
August 8, 2011 at 12:53 am
amenjonathan:
Sorry but didn't attach the sql plan for the script above. If you look they both give the same plan. I'm not saying that this is a given in all...
August 5, 2011 at 10:30 am
tablockx should do the trick but i'd look into the reason why there is 2 seperate processes trying to insert the same record.....
August 5, 2011 at 2:01 am
It does very much depend! A distinct won't always do a sort, i believe it will only do this if there isn't the relevant indexing on the columns selected.
As an...
August 5, 2011 at 1:45 am
micbra (8/4/2011)
August 5, 2011 at 1:22 am
Do you have any resource_semaphore wait types when the server has issues?? Or do you not get any issues per se (or that you're aware of at the time) and...
August 4, 2011 at 3:35 am
Only time i've had issues of a spid blocking itself this much is as Jeff stated, looping/cursor based procedures/scripts and sometimes parallelism.
As ninja says if you can provide us with...
August 4, 2011 at 3:01 am
I always shudder when i see that many LEFT JOINs as well as SELECT INTO's.......
As stated by others, from a quick glance over it there are a number of things...
August 2, 2011 at 12:29 pm
this may sound a daft idea but have you tried reverting everything back to how it was? This way you can determine for sure whether it was actually your changes...
August 2, 2011 at 12:12 pm
can you elaborate on what you mean by the server is locking? Do you mean no one can access it, its running dog slow etc etc?
During this period have you...
August 2, 2011 at 1:28 am
how big is the page file? If its 10GB and 25% used then i'd say you need more RAM. You want as much going through RAM and as little written...
July 28, 2011 at 1:20 pm
check out Paul Randall's post here regarding checkdb on vldb's.
Partitioning helps but i'd recommend running these commands during a quiet period or out of hours if possible.
July 28, 2011 at 1:14 pm
I know we spoke a while ago about my blog post on VAS becoming an article, I've followed it up as well so is it worth rewriting it as an...
June 28, 2011 at 12:47 am
Viewing 15 posts - 46 through 60 (of 178 total)