Information générale
Catégorie:
Applications Internet
>>SS 6.5, AFAIK, does support row level locking. I'm investigating this subject currently, so I don't have any concrete facts for you right now. I think the general scheme is that there is a lock escalation process that can cause you problems (and help n others, of course) with SS. I believe it is one of those behind-the-scenes approaches, and maybe your Oracle guy is referring to an explicit ability to control locking that SS does not have? There is a bit of a problem when the locks of 2 seperate processes are blocking each other, this could also be what your Oracle guy was talking about.
>>
>>I just picked up a copy of "The SQL Server 6.5 Performance Optimization and Tuning Handbook" by Ken England (ISBN: 1-55558-180-3, from amazon.com). It looks like it has a fairly good discussion of locking, but I haven't sunk my teeth into it yet.
>>
>>HTH,
>>Scot.
>
>The "ORACLE MAN" has left the building or shall we say he has "parted ways with the company". It looks like I'll be going with SQL Server after all !!!
ROFL....I've worked the corporate scene long enough to realize that more often than not, this is how these decisions are made.....(s)
My main thing about Oracle is the cost. IMHO, this is also the big reason that SS is creeping up in market share.....
Scot.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement