How can we help you today? How can we help you today?

MIXED_PAGE_ALLOCATION

Hi !

The setting MIXED_PAGE_ALLOCATION is not covered by the intellisense:
-- Enable mixed page allocation 
ALTER DATABASE extent_management SET MIXED_PAGE_ALLOCATION ON;
GO

Thanks for fixing this!
torsten.strauss
0

Comments

4 comments

  • Michael Clark
    Hi Torsten,

    Thanks for your post! If you think this enhancement would be useful, would it be possible to post this feature on our UserVoice so that other users can vote on it?

    You can access SQL Prompt's UserVoice here:
    https://redgate.uservoice.com/forums/94413-sql-prompt

    Thanks,
    Michael
    Michael Clark
    0
  • torsten.strauss
    Hi Michael,

    honestly I think this is not an enhancement but covering the new syntax of SQL Server 2016.

    I thought that "suggesting a feature" is for a feature(!) and not for missing key words in the intellisense.

    What do you think?

    BTW Trying to suggest a feature is not possible:
    "You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas. "

    Thanks in advance!

    Torsten
    Friend of Redgate
    torsten.strauss
    0
  • Michael Clark
    Hi Torsten,

    Sorry to hear that you've run out of votes, but thanks for all the great feedback on UserVoice.

    We have added a ticket for this and will let you know when we fix it:
    SP-6078 Code completion - Setting MIXED_PAGE_ALLOCATION is not covered

    Thanks,
    Michael
    Michael Clark
    0
  • Harry Frankish
    Hi Torsten

    SQL Prompt 7.5 beta now suggests MIXED_PAGE_ALLOCATION. You can download it from here.

    Thanks again for your feedback. Please let us know if you have any other issues.

    Cheers
    Harry
    Harry Frankish
    0

Add comment

Please sign in to leave a comment.