Phil Jacobs

Phil began his career as a Member of the Technical Staff at Bell Labs. He worked in IT at Moody's Investors Service for 27 years supporting Structured Finance, his last position being Vice President - Senior Database Developer, and he is currently a senior SQL development engineer at Dynamic Healthcare Solutions. Phil holds a Sc.B. in Computer Science from Brown University and a M.S. in Computer Science from Purdue University.

SQLServerCentral Article

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 (3)

You rated this post out of 5. Change rating

2021-05-07 (first published: )

5,343 reads

Blogs

What happens when we drop a column on a SQL Server table? Where's my space?

By

This article was initially posted on SQLServerCentral @ 2024-04-26. Short answer: The column is marked...

Why the masters and what lies ahead

By

I recently graduated with a Master’s in Strategic Communication from the University of Delaware....

Copilot Reminded Me How To Find a File Handle

By

Recently I was trying to delete a folder and kept getting the “something is...

Read the latest Blogs

Forums

Adapt the query to 2012

By meryemkurs072

Hello I have a query that works as a loop but it is slow....

Invoke-SQLCMD

By Bruin

If my server has dashes seems like that is throwing an error -serverinstance at-ts-cblsql ...

Red Gate SQL Change Automation

By Simon Hundleby

Hi, What's happened to this product has it now become Flyway?

Visit the forum

Question of the Day

Automated Azure SQL VM Patching

There is an Automated Patching service for VMs running SQL Server in the Azure Cloud. This uses the SQL Server IaaS Agent Extension to work with PowerShell. What types of patches are installed with this service? Note: All updates are marked with tags, such as Important, Critical, or something else

See possible answers