Post reply

ALTER INDEX

  • August 18, 2009 at 8:10 am

    #1040892

    you can use ALTER INDEX.... WITH DROP EXISTING

    however all this does is drop the exising index and re-create

    if anyone is using the index at the time then the command will be blocked. In addition, your command will block other users

    how many rows are in the table you wish to create an index on ?

    MVDBA

  • August 18, 2009 at 8:15 am

    #1040902

    sp_spaceused. Shows you how much space is taken up by your indexes.

    The probability of survival is inversely proportional to the angle of arrival.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply