What are the challenges you face when working across database platforms? Take the survey
Options

MIXED_PAGE_ALLOCATION

edited March 1, 2017 9:22AM in SQL Prompt
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!

Comments

  • Options
    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
    Technical Lead, SQL Monitor
  • Options
    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
  • Options
    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
    Technical Lead, SQL Monitor
  • Options
    Harry FrankishHarry Frankish Posts: 53 New member
    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
Sign In or Register to comment.