Module 1: DATA AND PROCESS MODEL
Module 2: MASTER TABLES AND PAGES
Module 3: DOCUMENTS
Module 4: POSTING
Module 5: FEATURE INTEGRATION
Module 6: REPORTING
Module 7: STATISTICS
Module 8: DIMENSIONS
Module 9: ROLE TAILORING
Module 10: INTERFACES
Module 11: WEB SERVICES
Module 12: TESTING AND DEBUGGING
Module 13: SQL SERVER OPTIMIZATION
- Lesson 1: SQL Server for Microsoft Dynamics NAV
- Lesson 2: Representation of NAV Tables and Indexes in SQL Server
- Lesson 3: Collation Options
- Lesson 4: SQL Server Query Optimizer
- Lesson 5: SQL Server Query Optimizer
- Lesson 6: Data Access Redesign
- Lesson 7: C/AL Database Functions and Performance on SQL Server
- Lesson 8: Bulk Inserts
- Lesson 9: Locking, Blocking, and Deadlocks
- Lesson 10: SIFT Data Storage in SQL Server
- Lesson 11: SQL Server Profiler
Lesson 3: Collation Options
Collation Options : SQL Server supports several collations. A collation encodes the rules that govern the correct use of characters for either a language, such as Macedonian or Polish, or an alphabet, such as Latin1_General (the Latin alphabet that is used by Western European languages). Microsoft Dynamics NAV 2013 only supports the latest
Windows collations. Any database that is upgraded by Microsoft Dynamics NAV 2013 is converted to the most recent corresponding Windows collation. Each SQL Server collation specifies the following three properties:
- The sort order to use for Unicode data types (nchar, nvarchar, and ntext). A sort order defines the sequence in which characters are sorted, and the way that characters are evaluated in comparison operations.
- The sort order to use for non-Unicode character data types (char, varchar, and text).
- The code page that is used to store non-Unicode character data.
You can specify SQL Server collations at any level. Each instance of SQL Server has a defined default collation. This is the default collation for all objects in that instance of SQL Server, unless otherwise specified. Each database can have its own collation. This can differ from the default collation. You can specify separate collations for each column, variable, or parameter. Microsoft Dynamics NAV sets the database default collation for reference only. All columns that are created by Microsoft Dynamics NAV explicitly has the collation set.
It is a good practice to set the collation as generic as possible to the language that is most common to users. If all users speak the same language, set up SQL Server with a collation that supports that language. For example, if all users speak French, define a French collation on SQL Server. If users speak multiple languages, define a collation that best supports the requirements of the various languages. For example, if the majority of users speak western European languages, then Latin1_General collation is the best option.
Collation settings are defined in the Microsoft Dynamics NAV Development Environment when a database is created. You can change it afterward with some limitations.