Performance tuning

SQLServerCentral Article

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

2021-05-07 (first published: )

5,284 reads

The Basics - Level 1 of the Stairway to Query Store

  • Stairway Step

Introduction Instead of going straight into the topic of the Query Store, I would like to start this Stairway Series by mentioning a few performance tuning scenarios that are very common to production DBAs. I think most of us have been in one of these situations at some time: An application experiencing slowness after a […]

4.8 (5)

2020-10-07 (first published: )

6,110 reads

Blogs

WIT/DEI Mental Health and Wellness Day Challenge to Present

By

Back in December 2019, I started presenting my session on mental health with lots...

Daily Coping 24 Mar 2023–The Final Tip

By

Today’s coping tip is to discover the joy in the simple things in life....

Experimenting with RedisGraph on Docker and Windows

By

I have been experimenting a bit with graph databases, trying to learn more about...

Read the latest Blogs

Forums

dbatools - Connect-DbaInstance

By rothj

I have my SQL servers name, UserID (UID) and Password (PWD) in a table...

Extracting the string before and after the given character

By sathishkm

Hi All, I want to extract the string before and after the given characters....

BULK INSERT CSV with a fixed value for a field not in the CSV

By PS_Richard

Well, I hope the title explains what it is.  Currently, I have the following...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers