performance tuning

how to increase performance through management studio
except making indexeshow to increase performance through management studio
except making indexes

Wow. Good luck with that. Let us know how it goes.

hmscott|||Hows about writing more efficient SQL - that's always a good way...

ankur: a vague question will only ever get a vague answer.|||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 :)|||I just have to say: what a fantastic answer! :beer: