Re: How can I Improve query speed?

From: Jamie Collins (jamiecollins_at_xsmail.com)
Date: 10/11/04 

Date: 11 Oct 2004 01:13:57 -0700

soundneedle@hotmail.com (John) wrote ...

> Thanks for the detailed reply, Jamie...that gives me a lot to look at
> and play around with. Eventually, I'll need to go from Access to SQL
> Server. Maybe that'll help speed things up too.

Better to get the schema/query design correct than rely on a 'faster'
system <g>. Good luck.

Jamie. 

--

Relevant Pages

  • Re: Importing CSV File
    ... Thanks, John. ... the file would need to be visible to the Database server. ... Do While StartPos < Len ... I've never needed to use an ADP and don't have an instance of SQL server ...
    (microsoft.public.access.modulesdaovba)
  • RE: Access limitations/suitablity
    ... performance they had to convert to something like SQL Server? ... Converting the SQL is not too hard, but not a breeze, either. ... that come into play. ...
    (microsoft.public.access.gettingstarted)
  • Re: Full-Text Catalog does not build...
    ... John, thank you. ... from time to time during population I have got event about SQL ... Server machine has 6GB RAM, SQL Server uses AWE and has 5GB memory. ... dbo properties PK_properties 7 1 cat_neu_prop1 ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Return to previous stored procedure
    ... > John wrote: ... >> I am very weak on SQL 2000 so I am not sure if I am asking this right. ... > SourceSafe or an SQL IDE tool like Imceda Speed IDE for stored procedure ... It's never a good idea to edit direcly on the server, ...
    (microsoft.public.sqlserver.server)
  • Re: Windows Server 2003 Ent. x64 Edition - Full-text Tuning
    ... John - thanks for the info. ... Do you recommend running SQL using AWE for a dedicate DB server with 2G ... or is it 512M across all DB FT catalogs? ...
    (microsoft.public.sqlserver.fulltext)