[dba-SQLServer] Timeout

Arthur Fuller artful at rogers.com
Fri Aug 20 19:24:18 CDT 2004


I can't verify the internals but I agree with your suggestion. Almost
all SQL books suggest that Count(*) is highly optimized while
Count(MyField) is not.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Thursday, August 19, 2004 6:15 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Timeout


On 19 Aug 2004 at 13:38, John W. Colby wrote:

> SELECT     COUNT(ID) AS Cnt
> FROM         dbo.Conduit
> 
> Which is built by the query builder in EM.  The query times out. 
> [Microsoft][ODBC SQL Server Driver]Timeout Expired.  Anyone have a 
> clue where I go to increase this value so I can get a count.

Are you running this from the Query Analyzer or an Access (or whatever)
FE  
using OBDC.  If the later, go into the ODBC Manager in you Control Panel

Also, try Count(*) rather than specifying a field.

-- 
Stuart


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list