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

Articles with tag WHERE Rss

Search for any content tagged where

   Items 1 to 2 of 2   
 

Conditional WHERE Clauses and Boolean Algebra

Utilize simple boolean algebra and nullable parameters to implement conditional WHERE clauses without dynamic SQL.  Read more...
By Tony Alicea 2010/08/31 | Source: SQLServerCentral.com | Category: conditional
Rating: |  Discuss |   Briefcase | 17,494 reads

SQL WHERE Clause Optimization

SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query to use it...   Read more...
By Additional Articles 2009/09/25 | Source: SQL-Server-Pro | Category: t-sql
Rating:  Rate this |   Briefcase | 9,284 reads
   Items 1 to 2 of 2