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

Blogs

I’m Speaking at #SQLSatSpokane

By

I am super excited to announce that I have been selected to speak at...

Common commands and tasks to make dealing with Windows Core easier.

By

I don’t know how many of you are working with Windows Core these days...

Introducing The Undercover Catalogue

By

In this video, David give a quick introduction into the Undercover Catalogue.

Read the latest Blogs

Forums

Dynamic Connection String for Dataflow Task

By oogibah

Hey Guys, I've been tasked with doing a task where I connect to a...

SPN troubles - once more...

By KrisVerheyen

HEllo, I've been looking trough the forums on topics about setting and removing SPN's...

Archive CLOB data

By VastSQL

Dear All, How to archive a table having 10million records with one CLOB column?...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers