Performance tuning Query

This is Dastagiri from hyderabad .I have two years experience in Database’s SQL Server 2005, MySql, ADS servers.But I dint not understand how to apply performance tuning for large time taking queries.Could you please send me any material or video links to me.


Thanks,
Dastagiri.

Sir,

Advising you to get some good books on performance tuning.

http://www.sql-server-performance.com/tips/performance_main.aspx

http://www.mssqltips.com/category.asp?catid=9

http://msdn.microsoft.com/en-us/library/ff647793.aspx

Here are some of the useful links to start your performance tuning with SQL Server

Cheers,
Venkatesan Prabu .J
www.Kaashivinfotech.com