SQL Server Performance

index related

Discussion in 'Performance Tuning for DBAs' started by ivoryman, Nov 8, 2004.

  1. ivoryman New Member

    Hi, I have 2 queries. The first one is, if i have a non-clustered index on a primary key in a table, how do I convert it to a clustered index.
    Secondly, how do I determine the size of a table. Thanks.
  2. Twan New Member

    Hi ya,

    To change the index you'd need to drop the primary key and re-add it as a clustered primary key

    to get the size of table you can use sp_spaceused

    Cheers
    Twan
  3. satya Moderator

    ,...SP_SPACEUSED @UPDATEUSAGE='TRUE' to get optimum results.
    And refer to the books online for further information on indexes and space usage.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page