Welcome to Julian Kuiters Friday, October 19 2018 @ 09:15 AM AEDT

COLLATE

Glossary
COLLATE
Keyword used to define string collation used for a database, column or server. Can also be used to cast the collation of a column or variable when used in a t-sql expression.

SQL Server 2000 and SQL Server 2005 allow you to use Windows Collation Names or SQL Collation Names.

To see a list of valid collation names, run

SELECT * FROM ::fn_helpcollations()

See COLLATE on MSDN.

VLDB

Glossary
VLDB
Very Large Database. Typically considered a database with a total size ranging from hundreds of gigabytes (GB) to terabytes (TB), contining millions or billions or rows. Designed with scalability in mind, they use different performance optimisation techniques to smaller sized databases.