Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: | Category: conditional
Rating: |  Discuss |   Briefcase | 17,523 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,360 reads
   Items 1 to 2 of 2