Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

LivingForSqlServer

I am Ramkumar, 34 years old Consultant, trainer, blogger and speaker at SQL Server user group in India. I have more than 10 years of experience as a developer and SQL Server DBA. I love reading, teaching and blogging about SQL Server internals and performance tuning. My Facebook page: https://www.facebook.com/LivingForSqlServer

Archives: December 2010

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 levels and types of indexes with simple example

To start with, let’s create a simple table in test database named LearningInternals.

CREATE TABLE tExample6(

intEmployeeId int IDENTITY(1001 Read more

7 comments, 3,227 reads

Posted in LivingForSqlServer on 29 December 2010

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 , newbies need to understand concepts on Index architecture before moving on to see what is there inside index pages.

So, before going see internals of Clustered and NonClustered index pages, lets quickly recap some… Read more

11 comments, 3,565 reads

Posted in LivingForSqlServer on 27 December 2010

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 me and purpose of this blog.
2. I 've republished this part with some updates after getting comments from Seniors. 
    You may notice that I 've removed detailed explaination of… Read more

15 comments, 3,720 reads

Posted in LivingForSqlServer on 21 December 2010

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 IAM, data pages allocated to a heap table.

As all data, index and system pages stores data in hexadecimal format, knowledge of Hexadecimal to decimal conversion… Read more

9 comments, 2,626 reads

Posted in LivingForSqlServer on 19 December 2010

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, sys.partitions, sys.allocation_units and sys.system_internals_allocation_units system views.

 

Case 1 (simple table with record size less than 8000 bytes and no… Read more

7 comments, 4,148 reads

Posted in LivingForSqlServer on 16 December 2010

SQL Server Storage Internals Part 1 - Basics

 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.

This is my attempt to share my learning with beginners… Read more

5 comments, 2,612 reads

Posted in LivingForSqlServer on 13 December 2010

What happens when a query is submitted?

I know, We cant cover life span of query in short.  here is my another try to list some high level information to those who are new to SQL Server community.

1. SQL Server Network Interface (SNI) a protocol layer on Client establish connection to Server SNI using Network protocol such as… Read more

15 comments, 2,240 reads

Posted in LivingForSqlServer on 5 December 2010