Browse by Tags
All Tags » SQL ( RSS)
-
|
The usual rule for specifying a key in NAV is, that it will chose the first key that matches all the fields specified by SETCURRENTKEY, RunformLink, etc. Example: Table 21 "Cust. Ledger Entry" has the following keys (not all of them listed)...
|
-
|
The query below combines these three queries into one: Index Usage Query Recent Bocking History Table Information Query It can be used to just see the number of records in each table. But also by just changing "ORDER BY", it can be used to see...
|
-
|
Attached at the end of this post is a set of NAV objects that collects index usage information, and displays it in a NAV client so that you can sort tables by no. of Indexes / Index Reads / (Index) Block wait time, etc.: The tool is using these three...
|
-
|
Just a small tip that I use often when I have a large SQL Profiler trace. Rather than reading through trace files line by line, you can read it into a table and then query it. This syntax creates a new table in SQL Server and loads your trace file into...
|
-
|
The SQL query below shows a list of tables sorted by the largest tables first. For each table, the indexes in the table are shown. For each index it shows when the index was last used. The query is designed to collect various pieces of information in...
|
-
|
The discussion of the changes starting with Microsoft Dynamics NAV version 5 regarding the use of Dynamic cursors has already been addressed in the article titled "Cursor Types" on the SE Blog - http://blogs.msdn.com/microsoft_dynamics_nav_sustained_engineering...
|
-
|
This post describes one scenario in which this error occurs. There may be others. In the late 4.0 versions of the NAV executables, all tables in NAV had a clustered index created on SQL for the primary key (Index 0). However, the table objects in 4.0...
|
-
|
The link below lists build numbers, KB numbers and links to cumulative updates updates 1 to 9 for SQL Server 2005: List of build numbers and cumulative updates 1-9 for SQL Server 2005 Also see this post for relevance of SQL Updates to Microsoft Dynamics...
|
|
|
|
|
|
|
|