John W. Colby
jwcolby at colbyconsulting.com
Thu Aug 19 15:01:05 CDT 2004
I have purchased new disks to build this new SQL Server database on. I believe I have read that SQL Server uses 8k block sizes internally. Is it useful to format the hard disk to 8K sectors so that the SQL blocks map to sectors directly? Does anyone know if this helps or hinders? John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John Maxwell @ London City Sent: Thursday, August 19, 2004 1:58 PM To: 'dba-sqlserver at databaseadvisors.com' Subject: RE: [dba-SQLServer] Timeout I also get this problem using the query builder in EM but fine when use Query analyser If in rush for results may be worth switching while waiting for a proper solution to be posted. Regards john -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John W. Colby Sent: 19 August 2004 18:39 To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Timeout I am trying to run a simple count query on this big db I'm building. The SQL is 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. ID BTW is the "autonumber" PK. John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com