Re: Is it possible to use nolock type of hint in query

On 8/11/06, Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com> wrote:
>
> The example I heard in a presentation about SQL Server isolation levels
> was an airline seat reservation system: you wouldn't consider as available
> a seat that had been reserved by another session, whether committed or not.
> Dubious, probably just a way to cast SQL Server's inferior read consistency
> model in a positive light, but there it is.
>

Not a good idea IMNSHO.

If someone else is hesitant to choose the seat, I have every right to get it if the other party has not yet committed to it.

Committed: that's a joke.

;)

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l