In summary: This query shows a list of all tables and indexes in a SQL database to help identifying in which tables the most blocks happen, and to give a starting point for index tuning. For further details, refer to the original blog post.
There are a few places in Dynamics NAV, where you set them up once, and then forget. Unless, you do a new installation, you don’t really need to go through these setup fields again.
In several partners meetings I have heard this requests over and over again.
Claus, when we are planning an upgrade of Classic reports to RDLC reports, we do not always know which reports are actually being used at the customer site. It would be great to be able to log which reports are used so we know exactly which reports we need to upgrade to RDLC.
Vertalen
