What is tempdb used for part 2 in Hindi
Internal Objects
Joins and aggregations
Cursors
INSTEAD OF Triggers
Version Store
DML Triggers
Online Index Rebuilds
Snapshot Isolation
Query Operators
Sorts
Hashes
Spools
Temp Tables AND Table Variables
************************8*
worktables
Work tables are internal structures used for a number of purposes:
Service Broker
DBCC CheckDB
Cursors
Group By, Union, and some Order By statements
Spools
*Work tables are allocated to mixed extents
Work tables can be cached to improve performance
Work tables have a negative objectid
https://learn.microsoft.com/en-US/tro...
