2014-02-28 (first published: 2011-02-16)
13,414 reads
Todd Fifield
2014-02-21 (first published: 2010-08-16)
15,595 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,052 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,003 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,834 reads
Blogs
Pluralsight Free April
By Gail Shaw
It’s a few days into April, but not too late I hope to mention...
Daily Coping 7 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Reading a SharePoint List with Azure Logic App
Sometimes in life you have to do things you really don’t like to do....
Forums
Developer Edition
I am proposing to the business that we use SQL 2019 Developer in our...
SQL server agent stop working (the server threw an exception [0x80010105])
Hi, I have cluster SQL (2008) running under windows server 2008. The cluster is...
change data capture errors cdc_errors
The cdc capture job ran into errors on our prod server. The error reporting...
Ask SSC