2014-02-28 (first published: 2011-02-16)
13,488 reads
Todd Fifield
- Interests: Music Producing/Writing
2014-02-21 (first published: 2010-08-16)
15,816 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,024 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,235 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,921 reads
Blogs
Daily Coping 18 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure Cosmos DB – HTAP using Azure Synapse Link
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
Azure Cosmos DB – HTAP using Synapse Analytics
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
Forums
How to do Join
Hello, I am looking for output where EG_RequestID = 175998968 and Reissue from paymentID...
Connect to PostgreSQL as an External Data Source using PolyBase
Comments posted to this topic are about the item Connect to PostgreSQL as an...
Growing and Keeping Up
Comments posted to this topic are about the item Growing and Keeping Up
Ask SSC