KB3054180 - FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2014 SP1

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

More Information

The Microsoft.SqlServer.Types objects support Microsoft SQL Server Spatial data types for the SQL Server service and the client applications. The logic to populate a LineString object involves validation. The validation logic sorts vertices during the validation. The more vertices, the more work for the algorithm. This fix updates the sorting algorithm to include angular vectorization techniques that significantly improve the LineString performance.

You can enable the new algorithm in client code:

AppDomain.CurrentDomain.SetData("clr_feature_switch_map", 1);

Note This should only be set for one time. A crash may occur when you change it during the validation.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.