Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Best Practices Rss

   Items 1 to 6 of 6   
 

T-SQL Best Practices - Don't Use Scalar Value Functions in Column List or WHERE Clauses

A classic article by Gerg Larsen explaining how and how not to use a function within your T-SQL statements. Where you place your function within your T-SQL statements determines how your query will be processed and can severely impact the query execution plan and the performance of your query.   Read more...
By Additional Articles 2013/11/28 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 6,113 reads

T-SQL Best Practices – Don’t Use Scalar Value Functions in Column List or WHERE Clauses

Query performance can be affected by many different factors. This article introduces another best practice of how and how not to use a function within your T-SQL statements.  Read more...
By Additional Articles 2009/11/04 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 8,194 reads

Building Code that Promotes Plan Re-usage

This article, the third in the T-SQL Best Practices series, discusses how to write your code to promote cached plan re-usage. Understanding how white space and comments impact whether a plan is cached or an existing plan is re-used can help you minimize the number of plans your application is caching.  Read more...
By Additional Articles 2009/08/31 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 3,431 reads

T-SQL Best Practices – Part 2

Continuing our discussion covering T-SQL best practices, this article focuses on how to optimize writing a jack-of- all-trades stored procedure (SP).  Read more...
By Additional Articles 2009/08/10 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 8,672 reads

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,485 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,789 reads
   Items 1 to 6 of 6   
 
Tags
best and worst practices (2)    
miscellaneous (1)    
scalar function (1)