2014-02-28 (first published: 2011-02-16)
13,613 reads
Todd Fifield
- Interests: Music Producing/Writing
2014-02-21 (first published: 2010-08-16)
16,008 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)
42,762 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,422 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,073 reads
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
Cannot run DynamicSQL Statement to merge table with JSON
Hi there I have a problem with a dynamicSQL Statement. In this code, I...
find connection details for all ssis jobs
Hi, is there are way using sql that brings a list of the ssis...
Does SQL Server eventually terminate idle connections to the database?
We are only trying to answer the below questions regarding database connections for an...
Ask SSC