The Sort that Spills to Level 15,000
Paul White shows that SQL Server sometimes produces very misleading information about the impact of sort operations.
2016-10-24
3,412 reads
sort
Never Ignore a Sort Warning in SQL Server
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
The pros and cons of self-service BI: What every industry leader should know
The post The pros and cons of self-service BI: What every industry leader should...
Off to the PASS Data Community Summit 2024
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
Implement a RAG Solution Using Azure SQL Database
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
Forums
South Kerala Tour Packages
South Kerala tour packages offer an immersive experience into the heart of Kerala's natural...
Black Corgi Chihuahua Mix – Unique Look and Personality
Ever seen a corgi chihuahua mix black, or "Chigi"? This rare color variation makes...
How to change font size in Query window
I am running SQL Server 20.2. When I copy a query into the query...
Question of the Day
Cloud Sources for the Data Migration Assistant
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers