> here and it fairly quick. The bottom line is adding more memory to
> your SQL Server (and letting SQL Server access it) to get the query
> times down. If you are sorting the results, use a tempdb in ram of
> about 32 mb and it should really make a difference as well (but
> don't run out of memory, or SQL Server won't start!).
Absolutely ! When I was doing the online time pages, I found the
query time decreased by about 200% by simply adding the right indexes
to the table.
Regards,
Graeme
---Graeme Slogrove, BSc (Eng) Elec (Wits)FastLight Data Distribution cchttp://www.fdd.netTel: +27-(0)11-706-0212 Fax: +27-(0)11-706-0812