Phil Jacobs

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 (2)

2019-09-12

2,769 reads

Blogs

Pluralsight Free April

By

It’s a few days into April, but not too late I hope to mention...

Daily Coping 7 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Reading a SharePoint List with Azure Logic App

By

Sometimes in life you have to do things you really don’t like to do....

Read the latest Blogs

Forums

Daily Coping Tip 7 Apr 2020

By Steve Jones - SSC Editor

Daily Coping Tip: Rediscover your favourite music that really lifts your spirits. My thoughts:...

Developer Edition

By Admingod

I am proposing to the business that we use SQL 2019 Developer in our...

SQL server agent stop working (the server threw an exception [0x80010105])

By TecMath

Hi, I have cluster SQL (2008) running under windows server 2008. The cluster is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers