SQL and NAV is hot these days. More and more knowledge becomes available and more companies and freelancers start helping customers tuning their databases. Most of the problems exist in "older" databases. Especialy early version 3 databases have difficulties performing. Fortunalely version 5 of NAV is very much pre-tuned on SQL so you are not likely to run into big issues until the database reaches a big size or some customisations come into business. This blog is not about what you can do with indexes, maintenance or code changes but specificaly about "covering indexes". Something not…

This is a very common question these days, mainly because of the "big" 5.1 release scheduled end of this year. Many of us have been looking forward to having a more fancy looking client for a long time, especialy sales people since other ERP products are starting to become mory flashy. For a lot of old NAV users, a direct upgrade to the new 5.1 client can be a step that is just a little to big to take. So why not upgrade in smaller steps. Since the "roletailored" client (that is what they call it these days) requires a SQL engine that may seem like the obvious first step. If you are running…