Phil Jacobs

Optimize Your SQL by Reformulating the Spec

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

Blogs

Getting Started with SQL Prompt 10

By

This week we released SQL Prompt 10, which is an exciting milestone for us....

Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting

By

Check out this new series that I’ve started on Power Platform Quick Tips. This...

The curious case of CHAR(0)

By

Over the years I’ve seen quite a few strange things with SQL Server. This...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Learn from the Troubles of Others

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learn from the Troubles of...

a query displaying 0 instead of not showing

By ahsal

hello, the following query is displaying the result i want except i want it...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers