Welcome to Julian Kuiters Saturday, July 21 2018 @ 06:02 PM AEST

Data Dude

  • Contributed by:
Glossary
Data Dude
The simplest way to say "Visual Studio 2005 Team Suite Edition for Database Professionals". A suite of tools built by Microsoft for designing, deploying and testing SQL Server databases within the Visual Studio IDE.

Visit the Visual Studio 2005 Team Edition for Database Professionals A.K.A. DataDude website.

COLLATE

  • Contributed by:
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

  • Contributed by:
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.