SQLServerCentral - Guest Columnist: Todd Fifield

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,089 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,539 reads

Calendar Tables III - Changing Business Rules

The client wants to change a date based business rule Read more...

By Todd Fifield 2011/02/16 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 8,174 reads

Calendar Tables II - The Anchor

Show the results for a date even if there is no data. Read more...

By Todd Fifield 2010/08/16 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 8,442 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 2012/02/24 (first published: 2010/07/15) | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 24,465 reads