Archives: November 2010
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).
In this article, I am going to discuss about the basics of SQL server which is helpful for newbies.
Most of the people have to… Read more
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…