Query Tuning

Optimize Your SQL by Reformulating the Spec

  • Article

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,802 reads

Blogs

What Agent Jobs are Running??

By

Do you run SQL Agent Jobs in your environment?  Do you know what is...

Unboxing SQL Clone 2020 for a PoC

By

When I got a new machine, I had SQL Clone on my old machine,...

Daily Coping 4 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Extended Events

By Michael L John

I have set up an extended event to capture the queries users may be...

Script logins and all permissions: no longer supported in SSMS generate script?

By Maxer

Okay, maybe I've just gone crazy but I was certain it used to be...

Recursive Select runs slow

By Soleya

Hello, I have a recursive Select that runs ultra slow. My test table has...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers