SQL DownUnder CodeCamp 2007 – If only they taught SQL server at kindergarten (4)
Session-4
Topic: If only they taught SQL server at Kindergarten
Peter Ward peter@wardyit.com and www.wardyit.com and www.wardyit.com/blog
Some of the good practices covered…..Return only what is required, Avoid LOOPS and use data sets, Handling NULL’s, Avoid co-related Sub-queries (replace with JOINs and CASE statements), Implicit Insert column list (target column list be explicitly specified), TOP without an order by should be avoided, Temporary tables, Other common bad practices and connecting to SQL server (specify application name in the connection string)….
Presentation should be available at the SQL DownUnder web site.
Good session again. Thanks Peter Ward.
Some links from the session:
Australian SQL server user group: www.sqlserver.org.au
Ask a SQL Guru : www.askasqlguru.com
October 14, 2007
· 
Rahul Desai · 
No Comments
Posted in: SQL Server, Tools, Tips & Utilities, UserGroups and conferences
Leave a Reply
You must be logged in to post a comment.