Problem comparing ESRI census tract centroid to SQL Server point centroid

[LizKuhn]

How would I make a valid comparison using ARCGIS census tract population centroids within a one mile radius of an address to the results using a SQL Server geography spatial index of latitude and longitude points of centers of population within a one mile radius around the same address?  When counting the census tracts with population weighted centroids from ESRI ARCGIS that are within a one mile radius around an address in San Francisco, California as compared to the US Census Bureau center of population census tract points within a one mile radius of the same address as indicated by latitude and longitude using a SQL Server geography spatial index of the points, I am computing significantly different results.  

[MitchHolley1]

What are you trying to compare?  Number of results yielded by each process?  Difference of address values between the two?

[LizKuhn]

The number of tracts returned within a one mile radius.

[MitchHolley1]

You can use the Select By Location tool and specify a search radius within that.  Also, you can select a feature within ArcMap and use only that selected feature (center point) as the search input.