Viewing 11 posts - 1 through 11 (of 11 total)
Thanks for that.
I note that flag 1205 shows more detailed info - is this a good idea instead of 1204, or does it generate too much info? Is 1204 sufficient...
March 31, 2003 at 5:22 am
I have a couple of places where splitting a table is likely to be useful - in both cases there are two distict areas of information that are updated by...
March 28, 2003 at 12:44 am
The idea of using Count(1) sounds interesting - why is this better?
Also the BETWEEN statement - Is this this faster because it dosnt have to do three descrete checks?
I appreciate...
March 28, 2003 at 12:19 am
This is what i have not in fact (NOLOCK) - i'll see if any more deadlocks occur in the future...
quote:
March 28, 2003 at 12:09 am
Trouble is that by the time i know about this the process has been thrown off. If would be neat to be able to trap the deadlock event itself and...
March 28, 2003 at 12:05 am
Tne query is run as OpenStatic for this reason.
quote:
One thing to bear in mind when accessing databases using ADO is the cursortype....
March 28, 2003 at 12:00 am
It was a select that was being thrown out, although it is a horrible query (lots of joins).
quote:
Hey,If deadlocks increase, you can...
March 27, 2003 at 11:58 pm
I have done some reading and it appears that a SELECT can cause a deadlock because it needs to lock both the table and the indexes before it reads data,...
March 27, 2003 at 11:54 pm
In my experience the ideal is to have a realy good dba acting as gate keeper to the production systems, and a really good developer has gatekeeper from development to...
June 24, 2002 at 3:32 am
Well it's good to keep this topic under discussion. I agree that WA dosnt do anything for internet sites where there is a problem that has to be addressed.
However i...
June 24, 2002 at 3:18 am
SQLDMO has an application object that in turn has a function called 'ListAvailableSQLServers' that (strangly enough) returns a list of SQL servers on your network.
It's not perfect - it does...
January 16, 2002 at 2:54 am
Viewing 11 posts - 1 through 11 (of 11 total)