2014-02-28 (first published: 2011-02-16)
13,744 reads
Todd Fifield
- Interests: Music Producing/Writing
2014-02-21 (first published: 2010-08-16)
16,214 reads
Calendar Tables
Learn how to avoid complex date calculations and increase performance using calendar tables in this article from Todd Fifield.
2014-02-14 (first published: 2010-07-15)
43,620 reads
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.
2013-03-01 (first published: 2011-06-21)
26,701 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.
2012-09-07 (first published: 2011-02-28)
35,492 reads
Blogs
TSQL Tuesday #184: Mentoring and Sponsorship
Thank you to Deborah Melkin for hosting TSQL Tuesday this month! I’ve always considered...
T-SQL Tuesday #184–Mentoring
By Steve Jones
This month’s T-SQL Tuesday blog party is hosted by Deborah Melkin, and it’s a...
T-SQL Tuesday 184 - Mentorship
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Job requires X years of SQL... How do you respond?
I can't even tell you how many jobs I've seen that require "X years...
SSIS Execute Process Task forfiles not working
I'm trying to use forfiles in an Execute Process Task in my SSIS package...
Question of the Day
Partial Backups II
What is a partial backup for a read-write database?
See possible answers