A lot of times there are questions about the license in SQL. How to import it? At what scope serves the “Save license in database” toggle in Tab integration?
Here a short explanation:
*File=>Database=>Alter=>Tab Integration=>Save license in database.
A license can be cut to be used at server level (this means the same license and the same number […]
Filed under: NAVISION, NAVISION-DB, SQL | 2 Comments »
As we all (should) know, SQL is based on sets and NAV works iterative with records.
Sometimes it is possible to do set based programming also in NAV.
I just found an example in which we can speed up something thinking in sets (1 record is also a set!) instead of iterative. The beautiful thing is: it […]
Filed under: C/AL, NAVISION, NAVISION-DB, PERFORMANCE, SQL | 3 Comments »
Lately I have very little time to write blogs or to be online in general. But I found some time anyway to write a new how-to. Took me over a month anyway to write it.
I have noticed too many times that a lot of people use record-variables in a completely wrong way.
The smaller errors just […]
Filed under: C/AL, NAVISION, NAVISION-DB, PERFORMANCE, SQL | 1 Comment »
We all know that the theoretical limit is 1GB for the cache on the native database.
But the practical maximum we ever reached (or heard/read from others) is around 850MB.
The same for me. I never installed or heard someone install a native database service and got over that 850MB limit (and sometimes even getting there is […]
Filed under: NAVISION-DB, PERFORMANCE | 4 Comments »
Mark told me that his session was more-or-less the same as for Directions US. But I didn’t follow that so I will blog anyway.
Waldo already blogged about the session, so I would suggest to read also his blog (http://dynamicsuser.net/blogs/waldo/archive/2007/11/09/directions-diary-dev-session-migrating-from-c-side-to-sql.aspx).
SQL benefits are :
-better performancee
-higher availability
-better backup/recovery
-new technologies (analysis/reporting/integration services)
-64 bit technology.
Upgrade path for NAV2009 (this one […]
Filed under: DirectionsEMEA2008, NAVISION-DB, SQL | 1 Comment »
Eric will probably not blog about this session for obvious reasons.
I am not writing everything he said or showed, only the things that are most important or something I didn’t know myself.
In general performance problems are created by the application (80-90%) and sometimes (10-20% by infrastructure).
Filed under: DirectionsEMEA2008, NAVISION-DB, SQL | 3 Comments »
A lot of times, my colleagues ask me what the maximum size is for a Navision DB. And I suppose a lot of other persons want to know too.
This is the answer (or better: these are the answers):
3.01..5.00 : 256 GB (maximum 16 files of maximum 16 GB)
2.50..2.65 : 64 GB (maximum 16 files of […]
Filed under: NAVISION, NAVISION-DB | 5 Comments »
Create a new blog and join in the fun!