Updated applies to for PERSIST_SAMPLE_PERCENT#10347
Conversation
|
@olahallengren : Thanks for your contribution! The author(s) and reviewer(s) have been notified to review your proposed change. |
There was a problem hiding this comment.
Thank you @olahallengren for the feedback and the fix/update. The changes for the SQL Server supported versions should be consolidated (i.e. remove the reference to SQL Server 2019). We should also update this section to include SQL Database in Fabric.
I'll add those changes in a direct comment.
| #### PERSIST_SAMPLE_PERCENT = { ON | OFF } | ||
|
|
||
| **Applies to:** [!INCLUDE [sssql16-md](../../includes/sssql16-md.md)] Service Pack 1 CU4, [!INCLUDE [sssql17-md](../../includes/sssql17-md.md)] Service Pack 1, or [!INCLUDE [sssql19-md](../../includes/sssql19-md.md)] and later versions, [!INCLUDE [ssazure-sqldb](../../includes/ssazure-sqldb.md)], [!INCLUDE [ssazuremi-md](../../includes/ssazuremi-md.md)] | ||
| **Applies to:** [!INCLUDE [sssql16-md](../../includes/sssql16-md.md)] Service Pack 1 CU4, [!INCLUDE [sssql17-md](../../includes/sssql17-md.md)] CU1, or [!INCLUDE [sssql19-md](../../includes/sssql19-md.md)] and later versions, [!INCLUDE [ssazure-sqldb](../../includes/ssazure-sqldb.md)], [!INCLUDE [ssazuremi-md](../../includes/ssazuremi-md.md)] |
There was a problem hiding this comment.
Applies to: [!INCLUDE sssql16-md] Service Pack 1 CU4, (../../includes/sssql17-md.md)] CU1 and later versions, [!INCLUDE ssazure-sqldb], [!INCLUDE ssazuremi-md], and [!INCLUDE fabric-sqldb]
You may have to select the "copy markdown" option to see the full markdown.
|
Can you review the proposed changes? IMPORTANT: When the changes are ready for publication, adding a #label:"aq-pr-triaged" |
There was a problem hiding this comment.
Pull request overview
This PR updates the “Applies to” version information for the PERSIST_SAMPLE_PERCENT option in the UPDATE STATISTICS documentation to reflect its introduction in SQL Server 2017 CU1.
Changes:
- Updates the
PERSIST_SAMPLE_PERCENT“Applies to” entry from SQL Server 2017 “Service Pack 1” to “CU1”.
| #### PERSIST_SAMPLE_PERCENT = { ON | OFF } | ||
|
|
||
| **Applies to:** [!INCLUDE [sssql16-md](../../includes/sssql16-md.md)] Service Pack 1 CU4, [!INCLUDE [sssql17-md](../../includes/sssql17-md.md)] Service Pack 1, or [!INCLUDE [sssql19-md](../../includes/sssql19-md.md)] and later versions, [!INCLUDE [ssazure-sqldb](../../includes/ssazure-sqldb.md)], [!INCLUDE [ssazuremi-md](../../includes/ssazuremi-md.md)] | ||
| **Applies to:** [!INCLUDE [sssql16-md](../../includes/sssql16-md.md)] Service Pack 1 CU4, [!INCLUDE [sssql17-md](../../includes/sssql17-md.md)] CU1, or [!INCLUDE [sssql19-md](../../includes/sssql19-md.md)] and later versions, [!INCLUDE [ssazure-sqldb](../../includes/ssazure-sqldb.md)], [!INCLUDE [ssazuremi-md](../../includes/ssazuremi-md.md)] |
PERSIST_SAMPLE_PERCENT was added in SQL Server 2017 CU1.
https://techcommunity.microsoft.com/blog/sqlserver/persisting-statistics-sampling-rate/385575