2014-02-28 (first published: 2011-02-16)
13,613 reads
2014-02-28 (first published: 2011-02-16)
13,613 reads
2014-02-21 (first published: 2010-08-16)
16,008 reads
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)
42,762 reads
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,422 reads
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,073 reads
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Hi there I have a problem with a dynamicSQL Statement. In this code, I...
Hi, is there are way using sql that brings a list of the ssis...
We are only trying to answer the below questions regarding database connections for an...