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

  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.


    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page