The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]
2019-10-14
3,535 reads
As SQL developers, we tend to think of performance tuning in terms of crafting the best table indices, avoiding scalar and table valued functions, and analyzing query plans (among other things). But sometimes going back to the spec and applying some properties of elementary math can be the best way to begin to improve performance of SQL queries which implement mathematical formulas. This article is a case study of how I used this technique to optimize my SQL implementation of the Inverse Simpson Index.
2019-09-12
2,643 reads
Learn some of the basics of using Dynamic SQL in a short series of videos.
2019-08-12
6,915 reads
Previous Monday to the Start of the Previous Quarter
2019-07-29 (first published: 2019-07-18)
344 reads
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
2019-07-16
11,959 reads
By HamishWatson
This blog post is about the situation where after upgrading to the latest macOS...
By John
If you are at involved with the #sqlfamily, you are bound to hear about...
By damianwidera
This is the eight interview we have done. This time our guest is the...
Comments posted to this topic are about the item Protecting Data from the Inside
I have a field called 'jsonpayload' in a table called 'auditlog' that is populated...
Today we had our weekly team meeting. Part of my team is working on...
Ask SSC