• make sure that you have clustered index on almost each tables .

    Rebuilding clustered indexes can free up unused space from your db ..

    that still depends upon DB size,as you can not find its much effective on Smaller Db size.

    also as per the above person said never shrink your data file,it makes your indexes completely unused

    -----------------------------------------------------------------------------
    संकेत कोकणे