Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server Blog Forum

My name is Muthukkumaran Kaliyamoorthy and I am living in India (Chennai). I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server, and I’m specialized in Administration and Performance tuning.

Archives: November 2010




I dedicate this article to my senior DBA “Roshan Joe Joseph” who has helped me to write a script.

I have posted the updated INDEX DEFRAGMENTATION script here, which is already published in sqlservercentral (SSC).

For VLDB – Please use Ola…

Read more

11 comments, 1,058 reads

Posted in SQL Server Blog Forum on 23 November 2010

SQL server basics for beginners


In this article, I am going to discuss about the basics of SQL server which is helpful for newbies.

SQL-Structured Query Language (pronounced as SEQUEL) is a Database, computer language designed for managing data in relational database management system (RDBMS).

Most of the people have to… Read more

14 comments, 1,148 reads

Posted in SQL Server Blog Forum on 23 November 2010

sql server internal architecture


Database Physical Structure & Internals:

SQL server internals Allocation Map is important for DBAs. It will help to understand the database internals.


A Database is a collection of data that is stored (or) organized. We can manage and access data easily.
When we create a new database, by…

Read more

5 comments, 402 reads

Posted in SQL Server Blog Forum on 12 November 2010