SQL Server Definitions

This glossary explains the meaning of key words and phrases that information technology (IT) and business professionals use when discussing Microsoft SQL Server and related software products. You can find additional definitions by visiting WhatIs.com or using the search box below.

  • T


    In a database management system (DBMS), a tablespace is a logical group of data files in a database. A typical database contains at least one tablespace, and usually two or more. In a database, a tablespace plays a role similar to that of a folder on the hard drive of a computer. (Continued)

  • transcription error

    A transcription error is a specific type of data entry error that is commonly made by human operators or by optical character recognition (OCR) programs.

  • trigger

    A trigger (from the Dutch trekken, meaning to pull) is a lever which, when pulled by the finger, releases the hammer on a firearm.

  • U


    U-SQL is a Microsoft query language that combines a declarative SQL-like syntax with C# programming, enabling it to be used to process both structured and unstructured data in big data environments.

  • Universal Data Access (UDA)

    Universal Data Access (UDA) is Microsoft's model or framework for a single uniform application program interface to different software makers' databases, both relational and nonrelational.

  • V

    Versioned Object Base (VOB)

    A Versioned Object Base (VOB) is a centralized database that stores version information about the files and folders in a software configuration management (SCM) system.

  • view

    In a database management system, a view is a way of portraying information in the database.

  • X


    XQuery is a specification for a query language that allows a user or programmer to extract information from an Extensible Markup Language (XML) file or any collection of data that can be XML-like.

  • Y


    Yukon is the code name used for the beta version of Microsoft's SQL Server 2005. SQL Server 2005 is said to provide enhanced flexibility, scalability, reliability, and security to database applications, and to make them easier to create and deploy, thus reducing the complexity and tedium involved in database management.