Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning sp_spaceused returns same even after deleteing 3.5 lac records. RE: sp_spaceused returns same even after deleteing 3.5 lac records.

  • May 28, 2009 at 9:52 am

    #1001530

    Does this table have a clustered index? If not, you might see this behavior. I am not 100% sure but I have seen this happen in SQL 2000 but I have never come across this situation in SQL 2005 DB.

    -Roy