oROEchimaru
Supreme [H]ardness
- Joined
- Jun 1, 2004
- Messages
- 4,662
To those that agree 
https://connect.microsoft.com/SQLServer/Feedback/Details/3135172
https://connect.microsoft.com/SQLServer/Feedback/Details/3135989
SQL Standard 2016 is growing archaic and new features in SP1 are unusable due to limitations:
a. maxdop 1 of Index creation (no parallel processing) instead of matching server maxdop or at least maxdop 4 (some parallel processing)... you cannot use compression since the index process alone takes up 100% use of 1 core while 31 cores are idle (or 24)
b. max ram of 128GB in 2017 instead of 256GB or 512GB
c. 24 core limit in 2017 instead of 32
https://connect.microsoft.com/SQLServer/Feedback/Details/3135172
https://connect.microsoft.com/SQLServer/Feedback/Details/3135989
SQL Standard 2016 is growing archaic and new features in SP1 are unusable due to limitations:
a. maxdop 1 of Index creation (no parallel processing) instead of matching server maxdop or at least maxdop 4 (some parallel processing)... you cannot use compression since the index process alone takes up 100% use of 1 core while 31 cores are idle (or 24)
b. max ram of 128GB in 2017 instead of 256GB or 512GB
c. 24 core limit in 2017 instead of 32