2015

  This defines how SQL Server will sort Case and Accents ( glyphs to determine pronunciation) and Kana (Japanese syllabic writing). Capitalization and the Diacritical ( Dia – through and krinein “to separate”) marks are included in sort considerations by SQL Server. Selecting the collation sequence on setup provide the Instance Collation however the collation…

When a double period is used, as in:   ExactMAXSampleDB..Part_Master   This means the schema is inferred to be the default schema of the current login.   In most cases this will be .dbo. So instead of having to provide it one could use the shortcut of the “..” or more correctly the default for…