Sometimes it is better to use SQL code instead of C/AL code to perform bulky operations. The reason is obvious: performance. Using SQL code is much faster. The upgrade procedure for Dynamics NAV 2013 uses SQL code to perform the upgrade on the Dimensions.
Posted inDynamics NAV & BC Tips & tricks