Browse by Tags

All Tags » Indexes (Get this RSS feed)

NAV Developer's Day - Update

Ankündigung: Microsoft plant aktuell die Durchführung eines " NAV Developer's Day " (vorläufiger Arbeitstitel ) Edit 30.10.2012: Achtung - Terminänderung! Stattfinden soll die erste Veranstaltung am 08. November 2012 17. Dezember 2012 (Abends) im Microsoft HQ in Hamburg...

MSDynamics.de Konferenz 2012

Am 09. Mai fand ja parallel zur " Tectura Convention 2012 " auch erstmals unsere " MSDynamics.de Konferenz " statt! WIr waren zwar ein kleinerer Kreis, hat aber viel Spass gemacht mal ein paar Gesichter hinter den Forums-Beiträgen zu sehen Ich durfte ja auch einen kleinen Vortrag...

NAV TechDays 2011 - Understanding Keys & Indexes with NAV & SQL Server

29th to 30th September 2011 in Antwerp (Belgium) Abstract : With Dynamics NAV and SQL Server it is important to understand how “ Keys ” and “ Indexes ” actually work; how they could/should be used within the C/AL code, which problems they could cause and how those could be solved...

Directions EMEA 2010 – NAV/SQL Performance: Indexes

Directions EMEA 2010 from 19 th to 21 st May 2010 in Prague/CZ. Website: http://www.directionsemea.com/ Well, actually this is not some new stuff, actually the presentation is quite similar (but stronger focus on indexes) than this one: http://dynamicsuser.net/blogs/stryk/archive/2010/02/10/technical...

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...

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 "...

DBCC DBREINDEX vs. DBCC INDEXDEFRAG

The following matters only for those who still run on SQL Server 2000 , as since SQL Server 2005 the DBCC DBREINDEX and DBCC INDEXDEFRAG actually have been replaced by the ALTER INDEX REBUILD/REORGANIZE command (I don't know if the following problem also affects ALTER INDEX). Why executing anyway...

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...

„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...

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...