Performance Tuning

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)

2019-09-12

2,767 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 […]

5 (3)

2019-05-13

3,358 reads

Blogs

Daily Coping 30 Mar 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Error handling protip: @@Error resets after the next command

By

The system variable @@ERROR is a quick and easy way to retrieve the error...

Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions

By

Introduction Recently have been working on a “Proof of Concept” task where I wanted...

Read the latest Blogs

Forums

The Coping Thread

By Steve Jones - SSC Editor

I've started a series on my blog about coping strategies during the pandemic: https://voiceofthedba.com/tag/life/...

Get the difference from one record to the one previous

By Meridian9300

In it's simplest form I want a table that I can use to store...

Regarding for Microsoft Azure Certification

By Ankitdixit

Hello Everyone, I am new here and I am preparing for microsoft azure certification...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers