Phil Jacobs

Phil began his career as a Member of the Technical Staff at Bell Labs. For the last 24 years he has worked at Moody's Investors Service where he is currently Vice President - Senior Database Developer in the Analytic & Technology Solutions Group supporting Structured Finance. Phil holds a Sc.B. in Computer Science from Brown University and a M.S. in Computer Science from Purdue University.

Optimize Your SQL by Reformulating the Spec

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.

5 (3)

2021-05-07 (first published: )

5,044 reads

Blogs

Container Limits and SQL Server

By

Limits in Containers Docker gives you the ability to control a container’s access to...

Inspector V2.6 now available

By

As always the code can be found here in our github repoWe updated our...

Data Mesh: Centralized ownership vs decentralized ownership

By

I have done a ton of research lately on Data Mesh (see the excellent...

Read the latest Blogs

Forums

Do You Have ALL the YAML?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Do You Have ALL the...

Why Power Query as an Activity in Azure Data Factory and SSIS?

By diponkar.paul

Comments posted to this topic are about the item Why Power Query as an...

Azure Blob Store Redundancy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Azure Blob Store Redundancy

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers