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
 General SQL Server Forums
 New to SQL Server Programming
 writing the correct SQL Statements

Author  Topic 

kid_on_the_block
Posting Yak Master

172 Posts

Posted - 2006-02-07 : 04:02:25
Hi

Is there any website that shows the best way to use the quesries, like using the best way to optimize the performance.

E.g. using Select * from tab , should not be used

But Select col1,col2 should be used

So need some tips like this plz help


Thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-07 : 08:31:48
http://www.sql-server-performance.com/developers_tuning_tutorial.asp

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2006-02-07 : 09:58:18
Do you know how to look at the execution plan?

[CTRL]+K



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page

kid_on_the_block
Posting Yak Master

172 Posts

Posted - 2006-02-07 : 22:34:37
ya but then do we have a tutorial, as to how to see what all the % & fiugres mean .....
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-08 : 00:57:27
http://www.sql-server-performance.com/query_execution_plan_analysis.asp

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -