question

[leafs]

Hi,

I am working with a slow database, how can I do to speed it up?

Thank you very much.

JW

 

[mkuan]

Adding indexes, and using stored procedures to retrieve, or manipulate queries may help.

 

[tlbroadbent]

Mkuan has given some good pointers though brief. Most SQL Server performance problems are related to databse and application design. See the following page for a number of SQL Performance related links.

http://tlbroadbent.home.attbi.com/sql_and_access/sql_performance.htm

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[SQLBill]

By the way, it can really help if you use an appropriate subject for your post. Some people might ignore a post of 'Question' because it doesn't give any idea of what it's about. A better subject/title would have been 'Slow database' or 'Need help with a slow database'.

Also, why not join Tek-Tips? It's free and you can get email notices when someone responds to your post.

Just a suggestion.
-SQLBill