2014-02-28 (first published: 2011-02-16)
13,371 reads
Todd Fifield
2014-02-21 (first published: 2010-08-16)
15,535 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)
40,311 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)
25,810 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)
34,809 reads
Blogs
Event Log File Paths
How does one consistently find the correct path to the Extended Event Log file...
Clearing an Email from the Microsoft Directory
By Steve Jones
Years ago I was working on a demo with Microsoft and someone added me...
Learning Containers
I find that I’m using containers more and more to get things done with...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
DBA Walkthrough – Adding space on IBM AIX Power Machines
Comments posted to this topic are about the item DBA Walkthrough – Adding space...
The Datatimeoffset Value
Comments posted to this topic are about the item The Datatimeoffset Value
Ask SSC