Re: locking

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 18:16:03 -0400

Eric is correct but I want to make one slight comment. SQL Server never
escalates to a page level lock from a row level. All escalation is always
to table level if it occurs. But it can choose to take out a page or table
level lock in the first place. 

-- 
Andrew J. Kelly
SQL Server MVP
"Eric.Li" <anonymous@microsoftnews.org> wrote in message
news:OMU0VgBSEHA.1392@TK2MSFTNGP09.phx.gbl...
> It depends. Default is row level, but optimizer may escalate it to page
> or table level locking if it see fit. You can force it to stay at row
> level by using query hints. Check query hints in BOL
>
> -- 
> Eric Li
> SQL DBA
> MCDBA
>
> Dan wrote:
>
> > How does SS2000 lock by default for a select, update and delete
statement.
> > Is it row level, page, table?
> >
> > Thanks,
> >
> > Dan
> >
> >

Relevant Pages

  • Re: Row level and column level permissions.
    ... "Arun" wrote in message ... column level permissions in an SQL server database. ... i could find some recommendations for implementing row level permissions.(I ... be applicable for my reporting tool(either crystal or sql reporting ...
    (microsoft.public.sqlserver.server)
  • RE: encrypt sensitive data
    ... the Crypto classes. ... SQL server 2005 will support encryption at row level. ...
    (microsoft.public.sqlserver.security)
  • Re: Evaluating Xml vs. One field per row in vertical app
    ... Did you take a look at some the SQL Server 2005 XML whitepapers on MSDN? ... Note that in SQL Server 2005 the granularity is still at the row level and ...
    (microsoft.public.sqlserver.xml)
  • Re: How does locking work in MSDE
    ... Exactly the same as in SQL Server. ... Locks are applied at the row level but ... MSDE Manager SQL Tools ... "Chris Bruyere" wrote in message ...
    (microsoft.public.sqlserver.msde)