SQL Server Myth on Clustered Index page allocation or B-Tree formation

Here is another SQL Server myth which I realised while understanding anatomy of index pages.
For a long time I...

My Favourite SQL Server Myths and Realities

It has been more than two months since I blogged. I have been blogging in my Organization internal blogging site on Management...

Why knowledge of internals is required for DBA? here is a valid reason

I got a report from development team that section of BizTalk communicating with SQL Server to update status
is frequently...

Evaluating Performance of View and Stored procedure

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...

Examining PFS, GAM and SGAM pages

Anyone who can interpret data and index pages will surely think about interpreting PFS, GAM and SGAM pages. I am...

SQL Server Storage Internals Part 6 – How to read Clustered and Non Clustered Index Pages

In this article we are going to see how index pages are organized with data pages and how to read different...

SQL Server Storage Internals Part 5 - Properties of Clustered and Non Clustered Index pages

In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...

SQL Server Storage Internals Part 4 - How to read a Heap page

I like to share 4 updates before moving on to this section:

1. I 've updated my profile to know more about...

SQL Server Storage Internals Part 3 - Architecture of Heaps

 In this article I have explained below topics
1. key points on HEAP tables.
2. What happens when a table is created.
3. How to list...

SQL Server Storage Internals Part 2 - Partitions and Allocation Units

 
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...