sp_estimate_data_compression_savings fails on tables with geography data type - by Greg Low - Australia

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 3137702 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/12/2017 6:02:30 PM
Access Restriction Public


When run against tables with a geography data type, sp_estimate_data_compression_savings returns "Error converting sys.geography to binary. The result would be truncated".
Sign in to post a comment.
Posted by Microsoft on 8/1/2017 at 2:31 AM
Thank you for taking the time to post this issue!
The fix is on its way and it will be part of SQL Server 2016 SP1 CU5 and SQL Server 2016 RTM CU8.

Mladen Andzic