2014-02-28 (first published: 2011-02-16)
13,669 reads
Todd Fifield
- Interests: Music Producing/Writing
2014-02-21 (first published: 2010-08-16)
16,106 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)
43,117 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,547 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,273 reads
Blogs
TryHackMe Advent of Cyber
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
You should be running on SQL Server 2022
It’s me again with my apparently semi-annual blog post. This time we’re going to...
Removing a PowerShell Array Element–#SQLNewBlogger
By Steve Jones
I saw an article on this and realized I had no idea how to...
Forums
Powershell, how to convert file to txt pipe
Hello, how can I change this code to txt pipe format? $DataSet.Tables[0] | Export-csv...
Summing different fields on a group by
HI I have a data set with student info; Name, Type there would be...
SQL AOAG with listener ( without windows clustering)
Hello, I am deploying SQL 2019 Enterprise edition with AOAG ( without windows clustering)....
Ask SSC