Alter page size

  • Could anyone tell me how to alter the page size? If i want to alter 8k page to 4k, can it be done?

    Thanks,

    Nagarjun.

  • Not sure I understand what you mean by page size, can you give more details?

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • No, SQL Server has a fixed 8k page size.

    Why did you want to alter it?

    Mike John

  • I just had got this doubt while reading an article about pages. Thanks its cleared!

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

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