2014-02-28 (first published: 2011-02-16)
13,428 reads
Todd Fifield
2014-02-21 (first published: 2010-08-16)
15,690 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)
41,262 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,044 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,838 reads
Blogs
Daily Coping 2 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting
By Will Assaf
Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...
MVP for Another Year 2020-2021
By Tim Radney
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...
Forums
Unusual use of the WHERE clause
I am working an exercise problem where the solution provided has a WHERE clause...
How to get the SSAS Server administrators in MDX query?
Hello, Is there any way to get the list of server administrators from SSAS...
Upgrading from SQL Server 2012 to SQL Server 2017 - Any Tips or Gotchas
We are running SQL Server 2012 SP4 Standard Edition on Windows Server 2012 R2...
Ask SSC