Home Forums SQL Server 2008 SQL Server 2008 - General Truncate table RE: Truncate table

  • March 25, 2013 at 9:14 am

    #1600362

    GilaMonster (3/25/2013)

    kevaburg (3/25/2013)

    Information related to non-clustered indexes are stored as a view in the MASTER database named sys.partitions.

    The view definition is in the system resource database. The data that the view reads is in the system tables of the user database and hence is stored in the specific user database, since views don't store information.

    Thanks for that Gail......a quick slip of the mind.... 😀