Number of Rows in Base Table Incorrect in sp_help_spatial_geography_index_xml - by Bob Beauchemin

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 475838 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/20/2009 2:25:59 PM
Access Restriction Public


The Number of Rows in Base Table reported by the sp_help_spatial_geography_index_xml is incorrect (it's too high), making the Average_Number_Of_Index_Rows_Per_Base_Row incorrect also. 

This is SQL Server 2008 SP1, correct counts were reported before SP1.

I'd suspect it was the same issue with the other spatial index stored procs too (sp_help_spatial_geography_index, sp_help_spatial_geometry_index, sp_help_spatial_geometry_index_xml) but don't have a repro for those.
Sign in to post a comment.
Posted by Milan [MSFT] on 4/30/2010 at 8:40 AM

this bug will be fixed for next CTP.
Posted by Bob Beauchemin on 11/5/2009 at 5:45 PM
Here's a repro script and a database backup. Some additional observations:

1. It doesn't happen with every spatial table and spatial index. It usually happens with large tables/indexes; it would be hard to post a 3 gb spatial database. So I've come up with the easier (and smallest) one to demonstrate.
2. It seems to happen more if the spatial database was built in pre-SP1 version of SQL Server. I built a lot of them pre-SP1; all of these seem to exhibit the problem.
Posted by Milan [MSFT] on 11/5/2009 at 7:21 AM
Hi Bob, we cannot repro the issue, can you please give us a database backup file which contains the issue you described.

Posted by Michael [MSFT] on 7/21/2009 at 6:50 PM
Thanks Bob... we will take a look.