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

Script changes:

·         I used while…

Read more

11 comments, 1,015 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,088 reads

Posted in SQL Server Blog Forum on 23 November 2010

sql server internal architecture


I am very glad to share my experience. I have two reasons to write this article here.

First one is I had an interview with one of the company, they asked about the SQL server internals. (On that time I struggled)

When I Goggled I didn’t get entire information…

Read more

5 comments, 370 reads

Posted in SQL Server Blog Forum on 12 November 2010