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

What Does It Mean to Make Data AI-Ready?

By

Making Data AI-Ready, Part 1 (This is the first article in a three-part series...

Using the Data API Builder–VS Live San Diego Resources

By

Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...

Running a Local LLM On Your Laptop Resources

By

Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...

Read the latest Blogs

Forums

Hyperscale Replicas II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas II

Practical Reporting Queries with CROSS APPLY (Part 3)

By Imran2629

Comments posted to this topic are about the item Practical Reporting Queries with CROSS...

Your Favorite Quotes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Your Favorite Quotes

Visit the forum

Question of the Day

Hyperscale Replicas II

How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?

See possible answers