Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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

INDEX DEFRAGMENTATION SCRIPT

 

INDEX DEFRAGMENTATION SCRIPT for 2008 / 2005

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, 633 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

12 comments, 679 reads

Posted in SQL Server Blog Forum on 23 November 2010

sql server internal architecture

Folks,

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

4 comments, 164 reads

Posted in SQL Server Blog Forum on 12 November 2010