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

Blogs

Creating a GitHub Actions Self-Hosted Runner

By

I had to demo the Flyway Autopilot system recently and created a GitHub Actions...

Migrating from Azure PG Single Server to Flex with Azure VM and pg_dump/restore

By

This is more complicated than using the Azure Migration method, but because it’s maxed...

PowerShell (and T-SQL) and Elastic Jobs

By

I’ve covered how to create Elastic Jobs in the portal (this one is important...

Read the latest Blogs

Forums

omegle

By Angelia M. Valletta

Okay, I understand. Based on the limited input ("Create New Topic in “SQL Server...

Contracting DBA - Permissions for initial analysis

By StephenSQL

Accidental DBA here.  After looking at all the work that needs to be done,...

How to convert run_date and run_time columns to datetime from SQL Agent systable

By Lord Slaagh

Hello SSC, Hope you are all having a great Monday! I am trying to...

Visit the forum

Question of the Day

AG Rules for Databases

Which of these is not a requirement for a database to be added to an Availability Group (AG)?

See possible answers