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 »
Well, first we didn’t plan a NAV Techdays 2012. We planned it for 2013. But here it is: NAV Techdays 2012.
I have good news and bad news about the sessions!
I’ll start with the good news: FULL (almost) of Dynamics NAV 7 …. erm… Dynamics NAV 2013 sessions!
The bad: guaranteed headache to choose the sessions you […]
Filed under: Dynamics, NAV, NAV2013, NAVTECHDAYS | Make a Comment »
It does compile without errors. But does it also run without errors?
datshipmentdate := 01072012D;
intDateDec := 9999;
intDateDec := (CREATEDATETIME(”datShipmentdate”, 0T) - CREATEDATETIME(010180D, 0T)) / 86400000;
MESSAGE(’%1′,intDateDec);
I’ll give the SQL answer (even if SQL has nothing to do with it): it depends.
It works on 4.0SP3 Build 25638,5.0SP1 Build 26084.
It gives an error on 5.0SP1 Build 30488,NAV2009 build 27808,NAV2009SP1 […]
Filed under: C/AL, NAV, NAVISION, Uncategorized | 3 Comments »
I have been using OneNote to write a blog post. After that, I copied the text directly to the blog. Not exactly the easiest way but it worked.
Now, I have discovered a new tool that works a lot better. It is from Microsoft and it is free (yes, they have free software too!): Windows Live […]
Filed under: Varia | 3 Comments »
Someone remembers I wrote about too many VLF in the transactionlog (http://mibuso.com/blogs/kriki/2008/12/23/some-tips-tricks-for-the-transaction-log/ ) and how to fix it?
Well, I just found a blogpost, stating that also the contrary can create performance problems.
Basically : if your VLF is too large, it takes too long before SQL Server can clear it and it takes too long to […]
Filed under: PERFORMANCE, SQL | Make a Comment »
Create a new blog and join in the fun!