Big Database

Hello all, i have a problem with a big database, the problem is that any query executed on that database, takes much much time, but i think that the db is over sized (5 gb aprox), because the table that contains most records has only 650.000, and i worked with db containing tables with more records and that not pass 1 gb.

Question 1: Why the db has grow so big?
Question 2: What can i do to speed up the querys?

Thanks for your help, and sorry for my english!I see that the database file has 650 mb (that's ok) but the log file has 5350 mb (that's absolutly wrong), i tried to truncate or shrink log file, but does'nt work.|||If you are not doing transaction log backups, you need to set the recovery mode to simple. After this, shrink the files and they will disappear to almost nothing. You only need full recovery mode, which is what you are probably using if your log files are that big.|||hey, i have reading a bit about that question of the recovery mode, but thanks for your suggestion, now my DB has 560 mb only!, that's great, but, the querys are a little bit slow yet!

Remember, i'm a programmer, not bilingual! jejeje|||Hello parmaia,
If you interested in making the queries to execute faster - I would start with doing a performance audit of your box . Check out sql-server-performance.com , Brad M. McGehee did a very nice series of articles on how to audit sql db server

http://www.sql-server-performance.com/sql_server_performance_audit.asp

If you run into questions, ask (either here or within sql-server-performance forums)

simas