If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Good database design. Well written queries. Well thought out indexes. A decent layout of data and log files on disk. Just a few of the things you want to consider, there's no single magic pill answer. Tuning a database server is like tuning a car - make the engine more powerful and you need a better exhaust, and a bigger gas tank as it's less fuel efficient, which add weight.
More power means better brakes and better cooling, which means more weight. Which in turn means more power and better brakes. Change one thing and it affects others, you can't alter anything in isolation in a database server without knowing the knock on effect. Point I'm making is you need to learn about the whole thing, not just one in isolation. There is no magic, single answer - unless you just turn it over to a decent DBA who's skilled in knowing what he's doing. This is where Management Studio stops poviding the answers and your brain has to start working hard, it's an aid to your mind, not a replacement ! Dig into SQL Server Books Online and start learning is my best advice