i got a very big problem help i need my database to execute one query in less
than a min but it executes for 8 mins is there any way i can shorten the
period of time execution?

Optimize the schema, the query, and then some.
Impossible to say without seeing DDL and sample data. A general description
of the server might also help.

Read this for clues:
http://www.aspfaq.com/etiquette.asp?id=5006


ML

---
http://milambda.blogspot.com/

Newbie - Query with loop?
Float vs Decimal
Using a trigger for Veritical Partitioning with a calculated table name...
Line item query
Fill in missing date ranges