In SQL Server, the page
size is 8 KB. This means SQL Server databases have 128 pages per megabyte. Each
page begins with a 96-byte header that is used to store system information
about the page. This information includes the page number, page type, the
amount of free space on the page, and the allocation unit ID of the object that
owns the page.
Page type of sort page
is 7.
When we performing the
sort operation temporary pages are created.
No comments:
Post a Comment
If you have any doubt, please let me know.