mathematical formula

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

Blogs

Idera GeekSync: SQL Security Principals and Permissions 101

By

Thanks to Idera and all 239 of you who joined the Idera GeekSync webinar...

Arrays in PowerShell–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Passwords = A Good Thing

By

Those my friends are, in my opinion, one of the single most wonderful things...

Read the latest Blogs

Forums

Looking for simple non-aggregate version of PIVOT to transpose Rows into Columns

By YSLGuru

I know I've found the answer to this before but I'm having trouble now...

Briefcase Missing Old Functionality

By TUellner

I haven't tried to save anything to my briefcase since the website rebuild. I...

Dynamic Partitions for Flight Data

By barclke

I am parsing 30+ meg binary files, as varbinary(max), containing parameter data from an...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Real REAL

See possible answers