2014-02-28 (first published: 2011-02-16)
13,585 reads
Todd Fifield
- Interests: Music Producing/Writing
2014-02-21 (first published: 2010-08-16)
15,962 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,589 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,361 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,017 reads
Blogs
Scary Scalar Functions - Part Four: Your Environment
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant...
Community Tools Month 2022 - dbatools
By alevyinroc
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...
Forums
How to copy XML converted data to file on local drive?
Hi everyone, So I have been working on converting my SQL tables data into...
The Growth of IQP
Comments posted to this topic are about the item The Growth of IQP
How to work with Python in Azure Data Studio
Comments posted to this topic are about the item How to work with Python...
Ask SSC