ADD LOG FILE argument

Ad hoc query parameterization

AdventureWorks2012 database

AFTER DML trigger

    application/business logic

    CREATE TRIGGER

    DELETED table

    INSERT/DELETE operation

    inserted and deleted virtual tables

    INSERT statement

    ProductionInventory table

    SET NOCOUNT

    tables

Aggregate functions

    average function

    CHECKSUM_AGG function

    COUNT and COUNT_BIG function

    GROUP BY clause

    GROUPING function

    MAX and MIN functions

    STDEV and STDEVP functions

    SUM function

    VAR/ VARP functions

ALTER APPLICATION ROLE arguments

ALTER DATABASE statement

    filegroup (see Filegroup)

    files (see Files)

ALTER INDEX

ALTER INDEX REORGANIZE

ALTER PARTITION FUNCTION statement

ALTER PARTITION SCHEME statement

ALTER PROCEDURE command

ALTER SCHEMA statement

ALTER TABLE REBUILD

ALTER TABLE statement

    column

        addition

        computed column

        modification

        removal

    COLUMN SET

    constraint

        addition

        removal

        temporary turn off

    NULL column storage

ALTER VIEW statement

    WITH ENCRYPTION clause

    view definition modification

ALTER XML SCHEMA COLLECTION statement

AND, OR, NOT operators

Appropriate indexing

Artificial keys

ASCII function

Atomicity, consistency, isolation (or independence), and durability (ACID)

AUTO_CREATE_STATISTICS database

@AWTables table variable

Backup

    compression

        factors

        vs. uncompressed backup

    database

    data files/filegroups

    differential

    mirroring

    normal sequence

    querying

    restoration

        CHECKSUM option

        DBCC CHECKDB

        RESTORE VERIFYONLY

    row/table

        business entity ID

        database snapshot

        deletion

        INSERT statement

        restoration

        SELECT statement

    transaction log

        BEGIN TRAN

        bulk logged recovery model

        COMMIT TRAN and a manual CHEKPOINT

        DBCC SQLPERF

        FillErUp

        INSERT loop

        logging database

        log_reuse_wait_desc option

        MSDN forums

Batch errors

BEGIN CATCH

BEGIN TRY

BETWEEN operator

BillOfMaterials table

Binary floating-point values

Blocking

    database session

    KILL command

    query editor session

    SQL server

    sys.dm_os_waiting_tasks DMV

    Transact-SQL

    troubleshooting blocks

B-tree structures

    clustered index

    nonclustered

Bulk-logged recovery model

BusinessEntityID 1

BusinessEntityId column

BusinessEntityID values

Cached query plan

    performance statistics

        problem statement

        sys.dm_exec_query_stats DMV

    record counts

        problem statement

        sys.dm_exec_query_stats DMV

CASE expression

    searched

    simple

CASE statement

Catch blocks

Category table

CHAR function

CHARINDEX function

CHECK constraint

COALESCE function

    nulls as zeros

    PhoneNumber return

    SELECT statement

CodeName

Column alias

Common table expression (CTE)

    arguments

    WITH clause

    derived query

    I/O statistics

    nonrecursive

    recursive

    temporary storage options

    vendor table

ComponentID column

ComponentID values

Computed column

CONCAT function

Concurrency

Constraint

    addition

        ALTER TABLE statement

        column constraint

        CREATE TABLE statement

        FOREIGN KEY constraint

        INSERT statements

        PRIMARY KEY constraint

        UNIQUE constraint

    removal

    temporary turn off

CONVERT function

Correlated subquery

COUNT function

CPU task scheduling

CREATE APPLICATON ROLE arguments

CREATE INDEX DROP_EXISTING command

CREATE INDEX statement

CREATE LOGIN arguments

CREATE STATISTICS command

CREATE TABLE statement

CREATE USER arguments

CreditCardApprovalCode

CROSS APPLY operator

Cross join

CTE. See Common table expression (CTE)

cteExpenses common table

cteMonths common table

CUBE argument

CURRENT_TIMESTAMP function

Database

    allocation structure consistency

    files (see Files) object

        definition view

        dependency identification

        name change

        referencing and referenced entities

        schema change

        schema name, and object ID

    principals (see Database principals)

    recovery

        differential Backup

        file/filegroup

        multiple recovery paths

        page

        piecemeal (PARTIAL) restore

        RESTORE command (see RESTORE command)

        transaction log

    shrinking

        data modifications

        DBCC SHRINKDATABASE command

        DBCC SHRINKFILE command

        index rebuilds

        VLFs

    space usage

    structural integrity

    system table consistency

Database principals

    application roles

    roles

        ALTER ROLE command

        CREATE ROLE command

        sp_helpdbfixedrole system stored procedure

    users

        ALTER USER command

        CREATE USER command

        DROP USER command

        orphaned user

        sp_helpuser system stored procedure

Database-scoped events

Database-scoped securables

    DENY arguments

    GRANT arguments

    managing permissions

    querying permissions

    REVOKE arguments

DATA_COMPRESSION clause

Data Definition Language (DDL)

    batch error handling

    triggers

        audit table

        CREATE TABLE/DROP TABLE statement

        CREATE TRIGGER

        EVENTDATA function

        index creation

        SET NOCOUNT statement

Data densification

DATALENGTH function

Data Manipulation Language (DML)

    AFTER DML (see AFTER DML trigger)

    batch error handling

    INSTEAD OF

Date

    arbitrary

    current date

    data type

    DATEADD and DATEDIFF functions

    DATEDIFF function

    DATEFROMPARTS function

    DATETIMEFROMPARTS function

    Datetimeoffset value

    DATETIMETOPARTS function

    elapsed time

    EOMONTH function

    FORMAT function

    Integer Representation

    intervals query

    ISDATE function

    missing

    national boundaries

    string value display

    value increment/decrement

DATEADD function

DATEDIFF function

DATEDIFF parameter

DATEFROMPARTS function

DATENAME function

DATEPART function

DATETIME2FROMPARTS function

DATETIMEOFFSETFROMPARTS function

DBCC CHECKALLOC arguments

DBCC CHECKALLOC command

DBCC CHECKCATALOG arguments

DBCC CHECKCATALOG command

DBCC CHECKCONSTRAINTS arguments

DBCC CHECKCONSTRAINTS command

DBCC CHECKDB arguments

DBCC CHECKDB command

DBCC CHECKFILEGROUP arguments

DBCC CHECKFILEGROUP command

DBCC CHECKIDENT

DBCC CHECKTABLE arguments

DBCC CHECKTABLE command

DBCC FREEPROCCACHE command

DBCC OPENTRAN

DBCC SHOW STATISTICS command

DBCC SHRINKDATABASE arguments

DBCC SHRINKFILE arguments

DBCC SHRINKFILE command

DBCC SQLPERF arguments

DBCC SQLPERF command

dbo.Test

DDL. See Data Definition Language (DDL)

Deadlocking

    DBCC TRACEOFF command

    DBCC TRACEON command

    DBCC TRACESTATUS command

    HIGH and NORMAL

    query editor window

    SET DEADLOCK_PRIORITY command

    SQL log

    trace flags

    victim

    winning connection query

DECLARE @account_balance decimal

DECLARE statement

DEFAULT constraint

Deferred name resolution

DELETE statement

@DeptCount variable

Derived table

DIFFERENCE functions

DISABLE TRIGGER

Disk Management

Distributed partitioned view

DML. See Data Manipulation Language (DML)

DMV. See Dynamic Management View (DMV)

DROP EXISTING clause

DROP INDEX command

DROP PROCEDURE command

DROP STATISTICS command

DROP TABLE statement

DROP TRIGGER

DupeCount

Dynamic Management Functions

Dynamic Management View (DMV)

    index usage

    sys.all_sql_modules

    sys.dm_exec_cached_plans

    sys.dm_exec_query_stats

        aggregated query performance statistics

        cached query plan performance statistics

        cached query plan record counts

    sys.dm_exec_requests, executable query capture

    sys.dm_io_virtual_file_stats, I/O contention

    sys.dm_os_wait_stats, bottleneck identification

    sys.dm_resource_governor_resource_pools

    sys.dm_resource_governor_workload_groups

Elementary programming

    CASE expression

        searched

        simple

    GOTO statement

    IF…THEN.  .  .ELSE statement

    RETURN statement

    value retrieval

    variables declaration

    WAITFOR statement

    WHILE statement

ELSE clause

EMPTYFILE parameter

ENABLE TRIGGER

Enable vardecimal storage

EOMONTH function

Error handling

    batch errors

    error numbers and messages

    nested error handling

    structured error handling see Structured error handling)

    user defined error see User defined error)

ERROR_LINE()

ERROR_MESSAGE()

ERROR_NUMBER()

ERROR_PROCEDURE()

ERROR_SEVERITY()

ERROR_STATE()

ESCAPE operator

EXCEPT operator

EXEC sp_db_vardecimal_storage_format

EXECUTE AS clause

Explicit transactions

    COMMIT/ROLLBACK

    DBCC OPENTRAN

    @@ERROR system function

    HumanResources.Department table

    sys.dm_tran_session_transactions DMV

    Transact-SQL code

    troubleshooting

ExtendedPrice column

FASTFIRSTROW hint

@@FETCH_STATUS function

Filegroup

    adding data

    adding file

    addition

    default setting

    integrity

    moving data

    read-only

    removal

Files

    data/log file

        addition

        logical name change

        relocation

        removal

    drives and directories

    logical name change

    size increase

Fishnet metaphor

Floating-point types

FORCE ORDER hint

FORCESCAN hint

FORCESEEK hint

FOREIGN KEY constraint

FROM clause

    FORCE ORDER hint

    multiple tables query

    specific column retrieval

GETDATE() function

GETUTCDATE function

Globally unique identifier (GUID)

GO command

GO statement

GOTO statement

GROUP BY clause

    CUBE argument

    custom summary

    duplicate elimination

    HAVING clause

    hierarchical summary

    summary group creation

    summary level identification

GROUP BY operation

GROUP BY ROLLUP clause

Grouping and summarizing

    COUNT function

    CUBE argument

    DISTINCT clause

    GROUPING function

    GROUPING_ID function

    GROUPING SETS operator

    HAVING clause

    OrderDate column

    ROLLUP argument

    SUM function

    TotalDue column

GROUPING function

GROUPING_ID function

GROUPING SETS operator

GUID. See Globally unique identifier (GUID)

HASH hint

HAVING clause

Hints

    FAST n hint

    index

        scan

        seek operation

    INDEX hint

    join order specification

    join’s execution approach

    OPTIMIZE FOR hint

    query execution without locking

    statement recompilation

HumanResources schema

IDENTITY column

    DBCC CHECKIDENT

    IDENT_CURRENT

    @@IDENTITY

    IDENTITY attribute

    INSERT statement

    property

    SCOPE_IDENTITY

    seed and increment

    SELECT statement

    SET IDENTITY_INSERT ON statement

    surrogate keys

IF statement

IF.  .  .THEN.  .  .ELSE statement

Index

    build performance and concurrency

    FROM clause

    CREATE INDEX command

    database

    defragmentation

    disk error

    DROP INDEX command

    existing index

    filegroup creation

    FILLFACTOR

    fragmentation

    full-table scan

    heap

    INCLUDE

    intermediate leaf level

    leaf level

        clustered index

        nonclustered

    maintenance

    multiple column creation

    non-key column table

    ONLINE option

    PADINDEX

    PAD_INDEX option

    page and row index lock

    parallelism creation

    partition

    PK_Customer_CustomerID

    rebuild

        ALL keyword

        ALTER INDEX

        heap table

        ONLINE option

        Purchasing.ShipMethod table

        uncompressed

    root node

    rows subset

    SELECT clause

    size reduction

    sort order column direction

    sp_helpindex system

    SQL server

    sys.dm_db_index_usage_stats DMV

    sys.indexes system

    Tempdb sorting

    tuning

    WHERE clause

Indexed views

    clustered and nonclustered indexes

    COUNT_BIG aggregate function

    Enterprise Edition

    ProductName column

    WITH SCHEMABINDING clause

    WITH SCHEMABINDING option

    SELECT statement

    SET STATISTICS IO command

INNER JOIN

Inserting

    command arguments

    default values specifying

    GUID

    IDENTITY column

    inserted rows returning

    multiple rows

    new row

    from query

    from stored procedure

    syntax

INSERT statements

Integrity

    constraint

    database

    filegroup

    tables and indexed views

INTERSECT operator

I/O contention

ISDATE function

ISNULL function

    CreditCardApprovalCode

     vs. IS NULL operator

    SELECT statement

IsWorkingDay column

Large tables and databases partition

    ALTER PARTITION FUNCTION statements

    ALTER PARTITION SCHEME statement

    ALTER TABLE.  .  .SWITCH statement

    boundary values

    column

    compressing table data

    CREATE INDEX DROP EXISTING

    CREATE TABLE statement

    data type

    DROP PARTITION FUNCTION statement

    DROP PARTITION SCHEME statement

    filegroups

    heap rebuild

    MegaCorpData

    nonpartition

    $PARTITION function

    RANGE LEFT boundary

    RANGE RIGHT boundary

    scheme

    system view sys.partitio

    table locks

    VLDB manageability

LEFT function

LEN function

LIKE operation

Lock escalation

Locking

    escalation

    OBJECT_NAME function

    query editor window

    resource_associated_entity_id

    SQL server lock modes

    SQL server lock resources

    sys.dm_tran_locks

Lockingconcurrency problems

LOGINPROPERTY function

Logon trigger

LOWER function

LTRIM function

MAXDOP index

MERGE statement

Merging data

MODIFY FILE arguments

MODIFY FILE clause

Modulo operator

Multiple tables query

    both sides join

    deduplication

    EXCEPT operator

    INTERSECT operator

    joins

    many-to-many relationships

    NOT EXISTS operator

    one side join

    parent and child rows correlation

    result set selection

    row combinations

    subqueries

    table subsets

    testing

        against result

        row existence

    two tables comparison

        differences

        duplicate row creation

        PasswordCopy

        Password table

        union query

    UNION ALL operator

    unions

Name column

Name value

NCHAR function

Nested error handling

Nested loops join

Nesting triggers

@@NESTLEVEL value

NEWID() function

NEWID/NEWSEQUENTIALID system function

NOLOCK table hint

Noncorrelated subquery

Non-NULL BusinessEntityID

Non-NULL value

Nonoptional/anchor table

Nonparameterized stored procedure

NOT FOR REPLICATION argument

NOT operator

NULL

    arguments

    COALESCE function

    column storage

        COLUMN SET

        CREATE/ALTER TABLE command

        row insertion

        SELECT statement

        SPARSE column attribute

        SPARSE storage attribute

        UPDATE statement

    functions

    ISNULL function

    IS NULL operator

    joining tables

    NULLIF function

    operand

    referential integrity

    SELECT statement

    uniqueness

    values

        check

        rows return specification

Nullable columns

    joining tables

    referential integrity

NULLIF function

Numbers

    binary floating-point values

    decimal data

    decimal storage

    floating-point values

    guarding against errors

        CAST and CONVERT

        SQL server

    integers representation

    mathematical expressions

    monetary amounts

    NEWID() function

    nulls

    RAND() function

    round

        CEILING

        decimal places

        FLOOR

        nonzero

    row set generator

NVARCHAR parameter

OBJECT_DEFINITION function

OBJECT_ID function

OBJECT_NAME function

OBJECT_SCHEMA_NAME function

OFFSET and FETCH clauses

ON clause

OPENXML command

OPTIMIZE FOR UNKNOWN

OPTION clause

    FAST n hint

    FORCE ORDER hint

    RECOMPILE query hint

ORDER BY clause

    deduplication

    OFFSET and FETCH

    parent and child rows correlation

    sorting results

    UNION ALL operator

OR operators

Partitioned view

    advantages

    CHECK constraint

    creation

    partitioning column

    records insertion

    SELECT list

    underlying tables

    UNION ALL statement

    WebHits table

$PARTITION function

PasswordHashAlgorithm property

PATINDEX function

Performance tuning and optimization. See Query performance tuning

Permissions

    fn_builtin_permissions arguments

    object permissions

        ALTER permission

        DENY arguments

        EXECUTE permissions

        GRANT arguments

        ReportViewers

        REVOKE arguments

        syntax

    securables

        Abridged Syntax arguments

        AdventureWorks2012 database

        database-scoped permissions

        database-scoped securables (see Database-scoped securables)

        DENY

        fn_my_permissions arguments

        fn_my_permissions function

        GRANT

        Has_perms_by_name arguments

        Has_Perms_by_name system function

        hierarchical scopes

        IMPERSONATE permissions

        non-SQL server resources

        ownership

        Production.Culture table

        REVOKE

        schema-scoped securables (see Schema-scoped securables)

        Server Audit object (see Server Audit object)

        server-scoped permissions

        server-scoped securables (see Server-scoped securables)

    SQL Server assignable permissions

    syntax

    sys.fn_builtin_permissions system catalog table function

Person.BusinessEntity table

PIVOT operator

Plan guide

    creation from cache

    query parameterization

    sp_control_plan_guide arguments

    sp_control_plan_guide system

    sp_create_plan_guide arguments

    sp_create_plan_guide system

    sp_executesql

    sys.plan_guides

    validity checking

PRIMARY filegroup

PRIMARY KEY constraint

Principals

    database

        application roles

        roles

        users

    SQL Server

        ALTER LOGIN command

        ALTER SERVER ROLE

        CREATE LOGIN command

        DROP LOGIN command

        fixed server role

        LOGINPROPERTY function

        sys.server_principals system catalog view

    windows

        ALTER LOGIN command

        CREATE LOGIN command

        DENY CONNECT SQL command

        DROP LOGIN command

        sys.server_principals system catalog view

ProductID column

ProductID values

Production.Document table

PurchaseOrderNumber

Purchase order numbers

Quantity column

Query execution plan estimation

Query execution statistics

Query performance tuning

    ad hoc query parameterization

    aggregated performance statistics

    bottleneck identification

    cached query plan performance statistics

    cached query plan record counts

    capture and evaluation

    configuration factors

    database design factors

    executable query capture, sys.dm_exec_requests DMV

    execution statistics

    guidelines

    hardware factors

    I/O contention identification

    miscellaneous techniques

    network throughput factors

    optimal query plan

    plan guide

        creation from cache

        query parameterization

        sp_control_plan_guide arguments

        sp_control_plan_guide system

        sp_create_plan_guide arguments

        sp_create_plan_guide system

        sp_executesql

        sys.plan_guides

        validity checking

    query execution plan estimation

    query resource consumption limitation

        ad hoc resource pool

        ALTER RESOURCE GOVERNOR

        ALTER RESOURCE POOL command

        ALTER WORKLOAD GROUP

        classifier function

        classifier user-defined function

        CPU task scheduling

        CREATE RESOURCE POOL arguments

        CREATE RESOURCE POOL command

        CREATE WORKLOAD GROUP arguments

        CREATE WORKLOAD GROUP command

        default and internal resource pools

        default workload group

        DROP RESOURCE POOL

        DROP WORKLOAD GROUP

        problem statement

        Resource Governor

        sys.dm_resource_governor_resource_pools DMV

        sys.dm_resource_governor_workload_groups DMV

        sys.resource_governor_configuration catalog view

        sys.resource_ governor_resource_pools catalog view

        sys.resource_governor_workload_groups catalog view

@QuerySelector

QuotaDate column alias

RAISERROR statement

RAND() function

READ COMMITTED

READ UNCOMMITTED

Rebuilding index

    ALL keyword

    ALTER INDEX

    heap table

    ONLINE option

    Purchasing.ShipMethod table

    uncompressed

RECOMPILE query hint

Recursive foreign key

RECURSIVE_TRIGGERS

Relational database

REPAIR options

REPEATABLE READ

REPLACE function

REPLICATE function

Resource consumption. See Query performance tuning, query resource consumption limitation

RESTORE command

    FROM DISK

    error/file corruption

    msdb database

    REPLACE argument

    RESTORE FILELISTONLY

    RESTORE HEADERONLY

    TestDB backup

    USE master

Retrieve data

RETURN statements

REVERSE function

RIGHT function

ROLLBACK

ROLLUP argument

@@ROWCOUNT variable

ROWGUIDCOL

Rows deletion

    DELETE statement with WHERE clause

    returning deleted rows

    truncating

RTRIM function

SalesOrderID

SalesQuota

SalesReasonID value

Sales.SalesOrderHeader table

Sales.SalesPersonOuotaHistory table

Sales schema

SalesTaxRate table

Schema-scoped securables

    CREATE SCHEMA arguments

    DENY arguments

    DROP SCHEMA command

    GRANT arguments

    managing schemas

    permissions managing

    REVOKE arguments

Scope qualifier

SELECT command

    AdventureWorks database

    all columns retrieval

    column building

    database connection

    list of values

    NULL values check

    paging, result set

    range of values specification

    renaming output columns

    rows return specification

        NULL value

        operators

        AND and OR logical operators

        WHERE clause

    search condition negation

    select_list argument

    sorting results

        columns not selected

        ORDER BY clause

        order specification

        ProductID and EndDate columns

        query returns

        unusual orders

    specific columns retrieval

    syntax

    table_list arguments

    tables shorthand names

    Transact-SQL language

    wildcard searches

SELECT.  .  .INTO statement

SELECT statement

    INTO clause

    DISTINCT clause

    GROUP BY clause

    MERGE statement

    retrieve data

    TABLESAMPLE clause

    table-valued function

    TOP clause

    UNION ALL set operator

    VALUES clause

Semicolon

SERIALIZABLE

Server Audit object

    CREATE SERVER AUDIT arguments

    CREATE SERVER AUDIT command

    database-scoped events

    managing, modification and removing

    predicate_expression option

    primary Server Audit object settings

    querying

        ALTER SERVER AUDIT command

        audit collection process

        BACKUP DATABASE text

        deletion events

        fn_get_audit_file arguments

        fn_get_audit_file table-valued function

        LesROIS_Server_Audit audit

        STATE option

        sys.dm_audit_actions catalog view

    reserve disk space

    script

    SQL instance–scoped events

    sys.server_file_audits

Server role permissions

Server-scoped securables

    ALTER TRACE permission

    DENY arguments

    GRANT arguments

    managing permissions

    querying permissions

    REVOKE arguments

    server-level principals

SET DATEFORMAT login

SET LANGUAGE login

SET LOCK_TIMEOUT option

SET SHOWPLAN_ALL

SET SHOWPLAN_TEXT

SET SHOWPLAN_XML

SET STATISTICS IO command

SET STATISTICS PROFILE command

SET STATISTICS TIME command

SET STATISTICS XML command

SET TRANSACTION statement

Single row/set of rows

Singleton select

SkipInsert

SNAPSHOT

SORT_IN_TEMPDB

SOUNDEX functions

SPACE function

sp_addmessage

SPARSE column attribute

SPARSE storage attribute

sp_createstats

sp_dropmessage

sp_help system stored procedure

sp_procoption system stored procedure

sp_rename parameters

sp_settriggerorder

sp_spaceused stored procedure

sp_XML_preparedocument system

SQL injection

SQL instance–scoped events

SQL Server

    appropriate indexing

    autocommit

    AUTO_CREATE_STATISTICS database

    AUTO_UPDATE_STATISTICS database

    built-in monetary data types

    CONVERT

    data type precedence

    escalation

    explicit transactions

    floating-point types

    implicit transactions

    index fragmentation

    integer data

    ISNULL function

    isolation

    lock modes

    lock resources

    mechanisms

    operator precedence

    principals

        ALTER LOGIN command

        ALTER SERVER ROLE

        CREATE LOGIN command

        DROP LOGIN command

        fixed server role

        LOGINPROPERTY function

        sys.server_principals system catalog view

    query performance (see Query performance tuning)

    representing integer values

    single-bit Integers

    sys.dm_db_index_usage_stats DMV

    tinyin

    trace flags

StateProvince table

Statistics

    AUTO_CREATE_STATISTICS database

    CREATE STATISTICS command

    DBCC SHOW STATISTICS command

    definition

    DROP STATISTICS command

    filtered creation

    selectivity

    single-column

    sp_updatestats

    UPDATE STATISTICS command

Stored procedure

    benefits selling

    cached query plans

    creation

        CREATE PROCEDURE statement

        dbo schema

        deferred name resolution

        EXEC command

        results

        Transact-SQL query definition

    DBCC FREEPROCCACHE command

    definition view

    documentation

    encryption

    generalization

    modification

    nesting level

    optional parameters

    OUTPUT parameters

    removal

    security context

    start-up run

    Transact-SQL statements

Strings

    ASCII character value

    character/bytes count

    function types

    integer character and Unicode values

    leading and trailing blanks

    LOWER and UPPER functions

    multiple concatenation

    REPLACE function

    REPLICATE function

    REVERSE function

    similarity determination

        DIFFERENCE function

        LEFT function

        RIGHT function

        SOUNDEX function

    SPACE function

    STUFF function

    SUBSTRING function

    substring location

        character pattern

        CHARINDEX function

        PATINDEX function

Structured error handling

    implementation

    return an error

STUFF function

Subquery

SUBSTRING function

Surrogate keys

SWITCHOFFSET function

sys.dm_db_index_physical_stats dynamic management function

sys.dm_db_index_usage_stats DMV

sys.messages

sys.sql_expression_dependencies object catalog view

Table alias

TableName column

Tables

    cascading changes

        arguments

        dbo.Person table

        ON DELETE CASCADE

        PhoneNumberTypeID column

        primary key/unique key column

        referenced table

        table creation

        ON UPDATE

    column

        addition

        CHECK constraint

        computed column

        DEFAULT constraint

        IDENTITY column (see IDENTITY column)

        NULL column storage (see NULL, column storage)

        removal

    column modification

    constraint (see Constraint)

    CREATE TABLE statement

    data page size

    DROP TABLE statement

    metadata information

    recursive foreign key

    row overflow functionality

    SEQUENCE

    temporary storage

    UNIQUEIDENTIFIER data type

TABLESAMPLE clause

Table-valued function

    APPLY operator

    CROSS APPLY and OUTER APPLY

    Production.WorkOrder table

    right operand

    SELECT statement

    WHERE clause

    WorkOrderId value

TABLOCKX lock

Task scheduling.

TerminationReason table

THROW statement

Time

    current time

    data type

    Datetimeoffset value

    national boundaries

    zone conversion

TIMEFROMPARTS function

TODATETIMEOFFSET function

Top N rows

TotalDue column

Transaction

    ACID test

        concurrent

        explicit (see Explicit transactions)

        isolation

        locking behavior

        ALLOW_SNAPSHOT_ISOLATION

        qEndOfDayRate

        Person.AddressType table

        READ UNCOMMITTED

        Sales.CurrencyRate

        SERIALIZABLE isolation

        SET TRANSACTION ISOLATION LEVEL command

        SNAPSHOT isolation

        UPDATE

        properties

Transact-SQL language

trg_uid_ ProductlnventoryAudit trigger

Triggers

    AFTER DML

        application/business logic

        arguments

        CREATE TRIGGER

        DELETED table

        INSERT/DELETE operation

        inserted and deleted virtual tables

        INSERTED table

        ProductionInventory table

        Production.ProductInventory table

        SET NOCOUNT

        UPDATE

    ALTER TRIGGER

    DDL

        audit table creation

        CREATE TABLE/DROP TABLE statement

        CREATE TRIGGER

        database-scoped

        EVENTDATA function

        index creation

        server/database

        server-scoped

        SET NOCOUNT statement

    DML

    drop

    enable and disable

    INSTEAD OF DML

    logon

    nested

    recursion

    transaction

    UPDATE function

TRIM function

TRUNCATE function

TRUNCATE TABLE statement

Try blocks

TSQLRecipe_A database

TSQLRecipe_A.dbo.Contract

UDF. See User-defined functions (UDF)

UDT. See User-defined types (UDT)

UNICODE function

UNION ALL operator

UNIQUE constraint

UNPIVOT operator

UPDATE statement

UPDATE STATISTICS command

Updating

    affected rows returning

    large-value columns

    second table

@UpperFlag parameter

UPPER function

USE PLAN command

User defined error

    creation

    RAISERROR statement

    removal

    THROW statement

User-defined functions (UDF)

    benefits

    code reusability

    DROP FUNCTION

    inline functions

    metadata viewing

    modification

    multi-statement

        arguments

        CHARINDEX

        FROM clause

        comma-delimited array

        LEFT function

        RETURNS keyword

        @StringArrayTable

        STUFF function

        syntax

        WHILE loop

    natural key

    reusable code maintenance

    scalar functions

        arguments

        CREATE FUNCTION

        DROP command

        function parameter

        @IsSuspect bit flag

        LOWER function

        PATINDEX

        RETURNS keyword

        scalar_return_data_type

        SELECT clause

        SELECT * FROM HumanResources.Department

        SELECT statement

        SHUTDOWN and DROP HumanResources.Department

        SHUTDOWN command

        string setting, proper case

        syntax

        transact-SQL code

        @TSQLString parameter

        varchar(max) data type parameter

    types

    view replacement

User-defined types (UDT)

    creating

        14-character string

        column definition

        CREATE TYPE arguments

        dbo.AccountNBR

        local variable

        NOT NULL

        sp_help system

        syntax

    dependencies identification

    DROP TYPE command

    table-valued parameters

        benefits

        CHECK

        CREATE TYPE command

        data source generation

        Department table

        Department_TT parameter

        INSERT

        multi-rowset capabilities

        PRIMARY KEY

        READONLY keyword

        singleton insert procedure

        AS TABLE

        UNIQUE

USE statement

usp_SEL_contract dependency

VALUES clause

Views

    column list

    creation

    data modification

    data security and protection

    definition

        modification

        querying

        refreshing

    distributed partitioned view

    encryption

    indexing

        clustered and nonclustered indexes

        COUNT_BIG aggregate function

        Enterprise Edition

        ProductName column

        WITH SCHEMABINDING clause

        WITH SCHEMABINDING option

        SELECT statement

        SET STATISTICS IO command

    indexing COUNT_BIG aggregate function

    list in database

    partitioned view

        advantages

        CHECK constraint

        creation

        partitioning column

        records insertion

        SELECT list

        underlying tables

        UNION ALL statement

        WebHits table

    regular

    types

Virtual log files (VLFs)

WAITFOR statement

WHERE clause

    INNER JOIN

    intersection subquery

    NULLs

    IN operator

    return rows

    row existence

    soh.SalesOrderID IS NULL

    subquery

WHILE statement

Windowing functions

    aggregate functions

        logical window

        prior row, total calculation

        ROWS | RANGE clause

        running aggregations

        sliding aggregations

        subset of rows, total calculation

    analytic functions

        CUME_DIST and PERCENT_RANK functions

        FIRST_VALUE and LAST_VALUE functions

        LAG and LEAD function

        PERCENTILE_CONT and PERCENTILE_DISC functions

    OVER clause

        parameters

        syntax

    ranking functions

        DENSE_RANK function

        logically consecutive rows grouping

        NTILE function

        RANK function

        ROW_NUMBER function

        syntax

    sequences

Windows principals

    ALTER LOGIN command

    CREATE LOGIN command

    DENY CONNECT SQL command

    DROP LOGIN command

    sys.server_principals system catalog view

WITH CHECK OPTION clause

WITH ENCRYPTION clause

WITH RECOMPILE clause

Workload balancing. See Query performance tuning, query resource consumption limitation

XML data

    ALTER XML SCHEMA COLLECTION

    BookInvoice/OrderItems/Item node

    column creation

    CountryRegionCode

    DOCUMENT/CONTENT

    EXPLICIT parameters

    index

    INNER JOIN

    insert

    modification

    OPENXML command

    OPENXML function

    query method

    schema collection

    SELECT statement

    sp_XML_preparedocument system

    Tag column

    TerritorySales element

    value method

    VendorID and CreditRating columns

    FOR XML

    FOR XML PATH

    XML_schema_collections

    XML_schema_namespaces

    XQuery methods