Query performance

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)


2,727 reads

SQL Server Plan Cache Limits

  • DatabaseWeekly

Erin Stellato explains the limits on both plan cache size, and number of entries. If you’re seeing plan cache bloat due to an ad hoc workload, take note of the space consumed by your plan cache and consider enabling the optimize for ad hoc setting.



I’m Speaking at #SQLSatSpokane


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.


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

Introducing The Undercover Catalogue


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

Read the latest Blogs


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


SQL Server Q&A from the SQLServerCentral community

Get answers