Browse by Tags

All Tags » SQL 2008 (Get this RSS feed)
Feb 16, 2010 12:00

Extended NAV/SQL Database Hardening

I really have a deep conflict here … we have recently started a "Database Security" project where we are developing solutions to fix certain NAV issues … so yes, this means there are " security issues ", and talking about potential solutions is not possible without describing...
Posted by Jörg A. Stryk | 3 comment(s)
Filed under: , , , ,
Feb 10, 2010 17:30

Technical Airlift 2009 (Munich) – NAV/SQL Performance Optimization: Indexes

Hi all, Puuuuhh, that was quite a rush … originally my idea about the TA was just to attend, but unfortunately one of the speakers got sick, and fortunately MS asked me if I could be available … <big grin> Of course I was available! </big grin> The pity was, I just had half...
Posted by Jörg A. Stryk | 6 comment(s)
Filed under: , , , , ,
Sep 26, 2009 11:34

Using SQL Server Full Text Search with NAV

A frequently asked feature for NAV is some kind of advanced search feature , which allows to search multiple fields of the same record at once . For example, to search for " Contacts " which have the expression "The" either in the " Name " or "Name 2" or "...
Posted by Jörg A. Stryk | 1 comment(s)
Filed under: , , , ,
May 18, 2009 13:43

Object Auditing

Recently in DynamicsUsers.net some "Wiki" was posted showing how to audit Object changes in NAV with SQL site Triggers; see http://dynamicsuser.net/wikis/navdev/auditing-who-changes-an-object-sql-only.aspx This actually describes how to add some fields to the NAV Object table and to save the...
Posted by Jörg A. Stryk | with no comments
Filed under: , , ,
Feb 12, 2009 18:53

BLOB Fields with NAV & SQL

BLOB = [ B inary] L arge OB ject Well, several tables in MS Dynamics NAV use such "BLOB"-fields to store binary data like pictures. This could be quite convenient for the application, for example for creating Item catalogues displaying such pictures, etc. but from a NAV/SQL performance perspective...
Posted by Jörg A. Stryk | 3 comment(s)
Filed under: , , , , ,
Dec 10, 2008 21:20

Prevent multiple Logins in NAV with SQL Server

Well, it is a frequently asked question „ How to prevent multiple logins of the same user in NAV? ". Usually the reason for this is to save client-licenses, or other things. When browsing the known web-forums you'll find several approaches to perform this; from executing 3 rd -party applications...
Posted by Jörg A. Stryk | 2 comment(s)
Filed under: , , , , ,
Nov 3, 2008 0:00

Blocks & Deadlocks in NAV with SQL Server

Well, "Performance Optimization" in NAV & SQL is some sort of "Cornucopia of issues" – starting from Hardware Sizing, Platform Configuration, Index Tuning, SIFT Optimization, etc. … and – last but not least – the question: " How to prevent and solve...
Posted by Jörg A. Stryk | 17 comment(s)
Filed under: , , , , ,
Aug 1, 2008 17:39

Index Statistics

Well, we all know that " Index Statistics " are crucial for optimized query processing in SQL Server, that we shouldn't use "Auto. Create Stats" or "Auto. Update Stats", that we should use "Jobs" or "Maintenance Plans" to keep them up to date, etc...
Posted by Jörg A. Stryk | 6 comment(s)
Filed under: , , , , ,
Jun 5, 2008 8:59

Downgrading NAV

Well, a current discussion is whether to go for NAV 5.0 Service Pack 1 or not. On the one hand, NAV 5.0 SP1 has lots of improvements regarding SQL performance (Indexed Views, Buffered Inserts, etc.), on the other hand there are other issues and problems (slow FlowFields, lacking SQL 2000 capability,...
Posted by Jörg A. Stryk | 11 comment(s)
Filed under: , , , ,
Jun 2, 2008 12:01

„Indexed Views“ performing slower than „SIFT Tables“ ?

Today I just ran a brief test to compare the performance of queries on " SIFT Tables " (older NAV versions) with queries on " Indexed Views " (introduced with NAV 5.00 SP1) called VSIFT . Well, in previous BLOGs or forum threads I already stated my concerns about " reading performance...
Posted by Jörg A. Stryk | 14 comment(s)
Filed under: , , , , ,
Oct 28, 2007 11:29

Included Columns vs. SIFT Tables

Base on David's "hint, hint ) I made my promise come true and copied this from a current thread: SIFT tables include aggregated information of e.g. "Ledger Entry" tables to display these values in FlowFields. The aggregation is done via SQL Server site triggers which are programmed...
Posted by Jörg A. Stryk | 5 comment(s)
Filed under: , , , , ,