|
|
-
|
|
While learning query tuning topics, I got a chance to understand anatomy of data
page and different types and levels of Index pages.
This learning helped me to understand concepts better and to give better performance
tuning solutions later.
......
|
|
-
|
|
I got a chance to evaluate performance of both views and stored procedure for high
level decision making.
As all of Us knows that purpose/scope of views and stored procs are different,
I have done this quick POC only to prove execution time of both views
......
|
|
-
|
|
In this section, we are going to see PAGE structure and anatomy of a heap page in
detail.
Structure of PAGE:
<v:f eqn="p......
|
|
-
|
|
In this article I have explained below topics,
Key points on HEAP tables.
What happens when a table is created?
How to list IAM, data pages allocated to a heap table.
As all data, index and system pages stores data in hexadecimal format......
|
|
-
|
|
Before moving on to see anatomy of different types of pages, lets spend some time
to understand the relationship among sys.objects, sys.partitions, sys.allocation_units
and sys.system_internals_allocation_units system views.
Case 1 (simple table with record......
|
|