Answer
SQL Server allocates memory for sorting, hashing, and aggregations.
Incorrect grants:
- Too small ? spills to TempDB
- Too large ? resource starvation
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ