Welcome to MSDN Blogs Sign in | Join | Help

September 2007 - Posts

Thursday, September 20, 2007 2:05 PM

Is SQL2000 more clever than SQL2005?

I have seen a number of (good) arguments that some issues with Dynamics NAV on SQL2005 are caused by a bad query optimizer in SQL2005, and that the SQL teams need to fix this. After all, some issues we see on SQL2005 did not exist in SQL2000. This blog
Posted by Lohndorf | 1 Comments
Filed under:
Wednesday, September 19, 2007 4:18 PM

Index Hinting in Platform Update for Microsoft Dynamics NAV 4.0 SP3 KB940718

Introduction On SQL Server, you can use index hinting to force the server to use a particular index when executing queries for FINDFIRST, FINDLAST, FINDSET, FIND('-') , FIND('+') , FIND('=') and GET statements. Queries generated by the form runtime will
Posted by martinni | 7 Comments
 
Page view tracker