Ever done that for 1 database? That’s easy. Just change the fin.flf in your DB server subdirectory. You don’t even need to restart the service.
Ever done that for 100 databases? That’s easy too. See my previous point, you just need to do that 100 times.
What do you say? You don’t want to? Well, neither do […]
Filed under: CLASSICCLIENT, NAV, NAVISION, NAVISION-DB | 2 Comments »
Who is still on native DB? You really should think of migrating to SQL Server.
I still find some customers that are still on native DB. Some of them have problems with performance but mostly because the database is quite old and keeps growing. When they started, they maybe had 100 or 200MB of memory and […]
Filed under: Dynamics, NAV, NAVISION, NAVISION-DB, PERFORMANCE | 1 Comment »
Now that the native database is destined to disappear, it is more than ever time to migrate your database to SQL Server.
Most migrations have some problems with dates.
If you have dates in your system before 1753/01/01 [rambling]Of all date-representations, I prefer the year/month/day because it is the most logical. After all, we write hundred and […]
Filed under: C/AL, NAV, NAVISION, NAVISION-DB, SQL | 1 Comment »
If you need to do something that smells like administrating NAV and you have little experience, this book is a very good start. Instead of searching through (and inside) all the pdf’s on the installation CD or googling/binging/yahooing blogs/white papers/articles all over the internet, you have all the basic information TOGETHER(!) in 1 book!
It won’t […]
Filed under: CLASSICCLIENT, NAS, NAVISION, NAVISION-DB, PERFORMANCE, RTC, SQL, Virtualization, WebService | Make a Comment »
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 | 5 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 »
Create a new blog and join in the fun!