sort

External Article

Never Ignore a Sort Warning in SQL Server

  • Article

It is always bad news if your SQL queries are having to use the SORT operator. It is worse news if you get a warning that sort operations are spilling onto TempDB. If you have a busy, slow TempDB, then the effect on performance can be awful. You should check your query plans to try to eliminate SORTs and never leave a SORT warning unheeded. Fabiano Amorim shows the range of ways of getting information on what is going on with a query that is doing a SORT and when requests are made for memory.

2015-04-13

8,822 reads

Blogs

Asking for Help Isn’t a Weakness

By

During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...

The Proof of the Backup Is in the Pudding

By

For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...

T-SQL Tuesday #204 – Are blogs still relevant?

By

Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....

Read the latest Blogs

Forums

SQL Server Vector Support II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Vector Support II

Great Things

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Great Things

Troubleshooting Slow Queries That Already Have an Index

By Imran2629

Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...

Visit the forum

Question of the Day

SQL Server Vector Support II

With regard to SQL Server 2025's Vector support, what is an embedding?

See possible answers