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

Guest Columnist: Todd Fifield

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

Using a Variable for an IN Predicate

How to use a passed string variable for an IN type predicate in your queries as a way to more efficiently handle an array of strings.  Read more...
By Todd Fifield 2013/03/01 (first published: 2011/06/21) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 25,615 reads

Key Word Searches

This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches.  Read more...
By Todd Fifield 2012/09/07 (first published: 2011/02/28) | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 34,684 reads

Calendar Tables III - Changing Business Rules

The client wants to change a date based business rule  Read more...
By Todd Fifield 2014/02/28 (first published: 2011/02/16) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 12,878 reads

Calendar Tables II - The Anchor

Show the results for a date even if there is no data.  Read more...
By Todd Fifield 2014/02/21 (first published: 2010/08/16) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 14,912 reads

Calendar Tables

Learn how to avoid complex date calculations and increase performance using calendar tables in this article from Todd Fifield.  Read more...
By Todd Fifield 2014/02/14 (first published: 2010/07/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 38,368 reads
   Items 1 to 5 of 5