Now: Tutorial for Web and Software Design > Database > MS SQL > Database Content
> Script: Database Defragmentation [Bookmark it]
Script: Database Defragmentation
SQL Scripts
May 7, 2006
Script: Database Defragmentation
By Rahul Sharma

Over a period of time, because of the inserts, updates and deletes, the data and the index pages can get fragmented. Here's a script that can help to defrag the database:

Click here for code.
[Bookmark][Print] [Close][To Top]
  • Prev Article-Database:

  • Next Article-Database:
    • Related Materias
    Configure DB2 remote conne
    Find the Zodiac
    Kill all DB Connections/SP
    Delete Old Files
    Create Partitions
    Script to Count Rows in SP
    Track Table Fragmentation 
    Script to Transfer Tables 
    Topics
    Photoshop Tutorial
     

    Special Effect
      3D Effect
      Photoshop Articles
    Programming Tutorial
     

    C/C++ Tutorial

      Visual Basic
      C# Tutorial
    Database Tutorial
     

    MySQL Tutorial

      MS SQL Tutorial
      Oracle Tutorial
    Graphic Design Tutorial
     

    Coreldraw Tutorial

      Illustrator Tutorial
      3D Graphics Articles
    Webmaster Articles
     

    Domain Service

      Web Hosting
      Site Promotion
    Java Tutorial&Articles
     

    Java Servlets

      JavaEE Tutorial
     

    JavaBeans Tutorial

    XML Tutorial&Articles
     

    XML Style Tutorial

      AJAX Tutorial
      XML Mobile
    Flash Tutorial&Articles
     

    Flash Video

      Action Script
      Flash Articles
    OS Tutorial&Articles
     

    Linux Tutorial

      Symbian Tutorial
      MacOS Tutorial