Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to improve sql performance

Author  Topic 

udaymahajan
Starting Member

17 Posts

Posted - 2008-08-14 : 00:37:35
how can i improve sql performance,so it reduces execution time,also can retrive or handle transactions on large amounts of data.

uday

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-14 : 02:37:37
try viewing execution plan and look for costly query steps and try optimizing them.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-14 : 08:39:10
Get knowledge from this:
www.sql-server-performance.com
Go to Top of Page

alvinlourdes
Starting Member

1 Post

Posted - 2008-08-14 : 08:53:16
Significantly improve your SQL performance by setting up various indexing options.

check out this site.
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1239952,00.html#

Alvin Lourdes
Go to Top of Page
   

- Advertisement -