Performance Tuning

Comparing Two Execution Plans

  • Article

This is a short look at a technique that I discovered recently in Management Studio (SSMS). The technique is to compare two graphical execution plans in the tool to understand what they are doing and how two different queries might affect a particular system, both with the image and with the properties' data behind the […]

5 (4)

2021-03-30

2,969 reads

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: )

4,954 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: )

5,701 reads

Blogs

P2 Puts Easy, Flexible Project Tracking Tools In Your Hands

By

Improve your team's workflow and productivity with these project tracking blocks.

Daily Coping 22 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Why are my permissions missing?

By

You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...

Read the latest Blogs

Forums

Handling OLEDB waits.

By JasonO

I have an application which runs on SQL 2016 & has a link server...

Finding the Group

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding the Group

How to create SQL script to backup transaction log with append

By itmasterw 60042

Hi,   I am trying to write a backup script, in a way that...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers