SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, Best and Worst Practices Rss

   Items 1 to 4 of 4   

T-SQL Best Practices

This article, the first in a series, discusses T-SQL coding best practices. Join Greg Larsen as he explains how to write queries to optimize SQL Server resources and improve performance.  Read more...
By Additional Articles 2009/07/24 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 8,871 reads

Two Best Practices!

This article presents two best practices. One is about how to construct good table aliases, the other is about using ANSI join syntax. Good stuff!   Read more...
By Darwin Hatheway 2003/12/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,831 reads

Worst Practice - Bad Comments

This one is pretty interesting, Andy discusses a few things he sees in comments that not only fail to add value, they end up costing extra time. There's room for discussion here, but definitely a discussion worth having - comments can make you or break you, here's a chance to think about what you think is important in commenting and pass that on to your development team.   Read more...
By Andy Warren 2003/01/23 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,426 reads

Worst Practice - Sorting by Ordinal

If you've been with us for a while you know that Andy started a series last year on worst practices. As he says, maybe you can't always do best practices, but at least dont do the worst ones. Read the article and add a comment, participate!   Read more...
By Andy Warren 2002/10/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,391 reads
   Items 1 to 4 of 4   
miscellaneous (3)    
best practices (2)    
programming (2)    
sql server 7 (2)    
worst practices (2)    
administration (1)    
naming standards (1)    
stored procedures (1)    
strategies (1)