MIXED_PAGE_ALLOCATION

torsten.strauss

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!

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

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

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

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