arithmetic expression

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

Blogs

Reviewing 2019 Career Goals

By

According to this post, I rate 2019 as a Failure. Of the books I...

ASF 029: Tomaz Kastrun interview

By

Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...

Schema Filtering in SQL Prompt

By

I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...

Read the latest Blogs

Forums

Can we use DC SQL Cluster Role name in DR Site (Same name Both Site)

By Harshana-455711

Hi I have SQL Server FCI running in my DC site following are cluster...

error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE

By webrunner

Hello experts, A client is reporting the following error when his application tries to...

Connectivity to Oracle 12.2 instance via OLE DB ?

By VoldemarG

I installed Oracle 12 on Windows 10 in  all possible ways/configurations, including the defaults....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers