General information
Category:
Internet applications
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only