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

Blogs

Getting the Proc Code–#SQLNewBlogger

By

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

Running SQL Server in Google Cloud Platform

By

On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows...

More ADLS Gen2 enhancements

By

On the heels of More Azure Blob Storage enhancements come more enhancements for Azure...

Read the latest Blogs

Forums

Copy Azure SQL DB App data to Azure Synapse

By DataBanker

Hello, I am looking for the best way to copy change data from my...

Enable normal user to execute a sys stored procedure

By SZ

I tried GRANT EXECUTE ON OBJECT :: sys.sp.droprolemember TO John; GO Cannot find the...

Enable user to execute a sys stored procedure

By SZ

I am struggling to enable a user to be able to execute a system...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers