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