Posted by Erland Sommarskog on 11/30/06 08:12

Gobwash (gobwash@gmail.com) writes:
> Thanks for the fast response. I just threw that out as a sample query,
> but if a where clause were present, what behavior should be expected?

It depends on the WHERE clause. If there is an index that can be used to
seek the rows, SQL Server will take out share locks. If there is no useful
index, so that the table will be scanned, there will be a table lock.

Again, aggregate or not has nothing to do with it.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Inserting into a tmp table using a View --- Please help using SQL Query Analyzer
• Prev in forum: Re: Need Emergency Help with SQL Query (difficulty: moderate)
• Thread view: Re: Aggregate functions and locking

[Reply to this message]