Tips in SQL

[Yogesh Jangam]

Hi
Thought of starting a Tips section for SQL in general
These tips usually applicable to SQL server but can some can also be
used for Oracle,mySQL or SQL Language in general

1. Do not use 'SELECT * FROM TABLE'
'SELECT * ...' is more costlier than 'SELECT Field1,Field2,...' on
SQL Engine
2. Use Stored Procedures.
Since SPROCS are compiled and run they are much more optimized than
calling
SQL Statements in your front-end code in Vb,ASP etc

P.S: These are just to get this started...will add more!!
Yogesh Jangam
http://yogeshjangam.blogspot.com