AccessKey

AccessKeyValue

AccountName: name1

Ad hoc SQL

advantages and disadvantages

parameterization

ALTER DATABASE command

CONVERT_IMPLICIT(nvarchar(4000),[@0],0)command

encapsulation layer

LIKE condition

N’1, rue Pierre-Demoulin’ value

simple query

sp_executeSQL

sp_unprepare and sp_prepare statement

SqlCommand object

pitfalls

batching interface

code-wrapping mechanism

functional code, transaction

low Cohesion and high coupling

performance tuning

security issues

SQL injection

runtime control over queries

bolded query

FROM clause

contact table

database creation

data changed property

IF blocks

sales.contact table

sales summary column

SELECT clause

UPDATE statements

varchar(max) columns

WHERE clause

Windows file-listing dialog

shared execution plans

SQL Server Management Studio

AFTER triggers

audit trail maintenance

change tracking and data capture

columnname

employee table

tablename

cascading inserts

child to parent cascading

databases and servers relationship

child insert and child update

demographics database

parent delete

parent update

DELETE trigger

disallow results set

Error logging section

Example.AfterTriggerExample

Example.AfterTriggerExampleGroupingBalance

GroupValue

INSERT statement

MERGE operation and statement

modification section

multiple rows

Accounting.AccountActivity table

accounting groups schema

AccountNumber

account table

FROM clause

error and updation

error message

trigger events

WHERE clause

summary value maintenance

AccountActivity and Account query

AccountActivity rows

Account table

BalanceAmount column addition and updation

Balance column updation

DELETE trigger

EXISTS filter

nested triggers

recursive triggers

trigger creation

TriggerDemo database

types

UPDATE trigger

utility.ErrorLog table

validation and cascading/modification action

validation section

Aggregation reporting style

additional summary tables

benefits, summary modeling

initial summary table

AllowMarketingByEmailFlag column

Alternate key (AK)

Analytical reporting style

Bill Inmon approach

denormalization

dimensional modeling

adjudication process

business process

date dimension

health care payer dimensional model

slowly changing dimension

snapshot fact

snowflake dimension

transaction fact (see Transaction fact)

type dimension

Ralph Kimball’s approach

Anti-patterns

generic key references

GUID key

JournalEntry

multiple tables, same key

objects, maximum usability/flexibility

RelatedTableName

SalesOrders

TroubleTickets

invisible physical layer

no datatype standardization

one-size-fits-all key domain

cached object

Customer table

data in query

domain tables

domain values

expandability and control

foreign key constraints

normalization process

one domain table per purpose

one multiuse domain table

one table application

performance considerations

relational databases

overusing unstructured data

poor domain choices

poor normalization practices

undecipherable data

Approximate uniqueness

AttendeeNumber

Attendees.AttendeeType

Attendees.MessagingUser table

AttendeeType

columns

domain

table

Auto dealer submodel

automobileMake row

automobileModelStyle table

AutomobileSale table

bCarFlag

BCNF. See Boyce-Codd Normal Form

bigint datatype

Bill Inmon approach

binary(N) datatype

bIsCar

bit datatype

BookISBN key

Boolean/logical values

Boyce-Codd Normal Form (BCNF)

multiple columns with same prefix

repeating groups of data

summary data

BuildInstance

Bulk uniqueness

baseplate types

bricks types

BuildInstance

BuildInstancePiece

CTE

data loading

grouping sets

InventoryAdjustment Quantity

InventoryAdjustment table

inventory and utilization storage

inventory model

Lego^® collection

minimal builds

personal inventory

Piece table

ProductSale Quantity

row constructor syntax

rows and data manipulation

sample Lego parts

table creation

table implementation

types of pieces

BusinessEntityID

Calendar table

BigSaleDaysFlag column

Business Intelligence/OLAP implementations

ON clause

CTEs

datename and datepart functions

final table

fiscal calendar

fiscal time periods

FORMAT command

insert statement

natural relational coding style/technique

normalization and denormalization

OLTP databases

OrderDate OrderTime, computed column

payroll system

query, fiscalYear

relative week count

2012 RTM version

table creation

time, floating windows

year column

CallId

CampActivity

Candidate key

Book_Name

composite key

definition

ISBN_number

natural keys

Publisher_Name

Smokey

surrogate keys

types

char(N) datatype

CHARINDEX function

Check constraints

ALTER TABLE statement

catalog number mask

WITH CHECK

chkMusic_Artist$Name$noMadonnaNames

chkMusic_Artist$Name$NoPetShopNames

complex expressions

data seeding

declarative constraints

error handling

errors enhancement

chkMusicAlbum$CatalogNumber$CatalogNumberValidate

entering invalid value

error description

ErrorMap table

error messages

error number

level

line

mapping table

rudimentary error-mapping scheme

state

TRY-CATCH error handling

example schema

INSERT statement

WITH NOCHECK setting

release-date column

simple expressions

chkMusicAlbum$Name$noEmptyString

date range checks

empty strings

LEN function

SSIS OLEDB output

trusted status and values

value reasonableness

sys.check_constraints catalog object

sys.check_constraints query

tables creating and populating code

triggers errors

constraint mapping function

doomed transaction

ROLLBACK

SELECT statement

THROW

transaction state

transaction without rolling back

TRY-CATCH block

utility.ErrorLog$insert object

UPDATE statement

using functions

Album table

Boolean expression

CatalogEntryMask

CatalogNumber column

CatalogNumberMask column

CLR-based objects

complex scalar validations

DML modification statement

Publisher.CatalogNumberMask

Publisher table

query

row with invalid value

single-row validation code

tables access validation

T-SQL function

UDFs

Chen Entity Relationship Model (ERD) methodology

ChildName

chunked updates

CLR

complex procedural logic and computations

extended stored procedures

guidelines

.NET framework classes

objects and functionality

object types

stored procedures

triggers

user-defined aggregates

user-defined functions

user-defined types

rich language support

string manipulation, complex statistical calculations and custom encryption

Visual Studio

Codd’s eighth rule

Code-based denormalizations

colFirstName

Collation

columnCity

Comma delimited items

Common Table Expression (CTE)

Concurrency coding

isolating sessions

isolation levels (see Isolation levels)

lock characteristics

lock modes

lock types

lost update

logical unit

MARS

multiuser database

optimistic locking

OS and hardware

parallelism

pessimistic locking

Resource Governor

row-based locking

add a time column method

check all columns method

optimistic lock columns

row-level optimistic lock coding

timestamp column method

single-threaded code block

tradeoffs

transactions

ACID

basic transactions

bulk logged model

checkpoint

definition

distributed transactions

DML and DDL statement

explicit vs. implicit transactions

full model

MARS

multiple commands

nesting transactions

savepoints

simple model

SQL Server Code (see SQL Server Code)

T-SQL code

ConnectedToUser

contact$delete procedure

Contacts.Journal table

CREATE SEQUENCE dbo.test

CREATE TABLE statements

CTE. See Common Table Expression

CustomerId

Data access strategies

ad hoc SQL (see Ad hoc SQL)

Entity Framework

interface creation

non-data tier rule

object-relational mapping tools

security and indexing strategies

stored procedures

advantages and disadvantages

AdventureWorks2012 table

complex plan parameterization

cross-platform coding

data format

data-manipulation code

DBA

dbo powers/sysusers

encapsulation

EXECUTE AS clause

fine-tuning without program changes

high initial effort

injection attack value

INSTEAD OF trigger

JOIN clause

mutable business logic and rules

optional parameters

precompiled stored procedures

quotename() function

RETURN statement

sales.contact table

salesLevelId column

salesLevel value

security

securityEXECUTE AS clause

sp_executeSQL and parameterization

structure

WHERE clause

Database access prerequisites

contained database model

advantages

ALTER DATABASE statement

authentication

ContainedDbSecurityExample database

contained user

CREATE DATABASE statement

CREATE USER statement

logging demonstration

Object Explorer

sp_configure

virtualization

WilmaContainedUser

database principals

database scope securables

DENY security statement

GRANT security statement

impersonation

login and user

CHECK_POLICY setting

ClassicSecurityExample database

CREATE LOGIN statement

database principal

FRED user rights

Management Studio user

password

REVOKE statement

server permissions

server principal

SQL Server authentication

tempdb database

Windows Authentication

REVOKE security statement

schema scope securables

server-scoped securables

server security guidelines

SQL Server principals

windows principals

Database-level security

impersonation

stored procedures and scalar functions

views and table-valued functions

column-level security

data, projection/vertical partitioning

error reporting

GRANT syntax

multistatement table-valued function

ProductViewer group

row-level security

Database lines

certificate-based trust

cross-database chaining

ALTER AUTHORIZATION statements

ALTER AUTHROIZATION DDL statement

ALTER DATABASE

containment level

cross database access

Cross DB Ownership Chaining

DB_CHAINING database option

externalDb database

OLTP databases

SELECT statement

server principal

smurf principal

sys.databases catalog view

TRUSTWORTHY database option

database-backup scenario

distributed queries

foreign key constraints

impersonation

Database securables

application roles

built-in database roles

column-level security

grantable permissions

object groupings

schemas

table security

user-defined database roles

Administrators role

database-level rights

DENY operation

Employees role

GRANT operations

HRManagers role

HR system

HRWorkers role

human resources system

Managers role

Payroll schema

T-SQL code

users security information

Data definition language (DDL)

basic check constraints

Boolean expression

MessageTopic table

NULL

TopicName

triggers, maintain automatic values

T-SQL

user-defined functions

UserHandle

validation routines

[WITH CHECK | WITH NOCHECK] specification

basic table structures

columns and base datatypes

nonnatural primary keys (See Nonnatural Primary Keys)

nullability

schema

ConferenceMessaging database

database design/generation tool

database documentation

Description script

Descriptions in Management Studio

fn_listExtendedProperty object

functions and procedures

Messages.Topic table

parameters

reindexing schemes

repository information

tables, column, and schemas limitations

data modeling tools

default constraints

Development Studio

foreign keys

addition syntax

ALTER TABLE statement

AttendeeType

CASCADE operations

CREATE TABLE statement

cross-database relationships

messaging model

MessagingUser and Message

parent-to-child relationship

SQL Azure

surrogate keys

Topic and MessageTopic

UserConnection

verb phrases

metadata

catalog view

INFORMATION_SCHEMA views

schema list

sys schema objects

table and column name

uniqueness constraints addition

alternate key constraints

indexes

primary key constraints

Data gathering

best practices

client interviews

communication gap

formal

one-to-one sessions

structured database

data integration with system

data location

data type needed and used

data worth

documentation

audit plans

contracts/client work order

early project

service level agreement

governing rules

multiuser data

reported data

requirements

artifacts

document

E-R modeling method

graphical model

large system

Scrum methodology

UML

systems and prototypes

waterfall process

Data Manipulation Language (DML) triggers

advantages

AFTER triggers

audit trail maintenance

cascading inserts

child to parent cascading

databases and servers relationship

DELETE trigger

disallow results set

Error logging section

Example.AfterTriggerExample

Example.AfterTriggerExampleGroupingBalance

GroupValue

INSERT statement

MERGE operation

MERGE statement

modification section

multi-row error

multi-row updation

range checks, multiple rows

summary value maintenance

trigger creation

TriggerDemo database

types

UPDATE trigger

utility.ErrorLog table

validation and cascading/modification action

validation section

and constraints errors

constraint mapping function

doomed transaction

ROLLBACK

SELECT statement

THROW

transaction state

transaction without rolling back

TRY-CATCH block

utility.ErrorLog$insert object

database option–ALTER DATABASE–RECURSIVE_TRIGGERS

deleted table

disallow results from triggers option

error logging procedure

EXISTS Boolean expression

inserted table

INSTEAD OF triggers

applications

DBMS

error handler

formatting user input

FormatUpper value

insert statement

multi-row operations

no action on table

<perform action> comment

redirecting invalid data

RowCreatedTime and RowLastModify time values

SCOPE_IDENTITY() function

UPDATE statement

modified columns determination

multiple AFTER triggers

multi-row considerations

nesting triggers

OLTP operations

performance

recommendation

SELECT statement

server option–sp_serveroption–nested triggers

stored procedure

trigger usage

T-SQL command

types

Utility.ErrorLog

Data modeling

alternate methodology

Chen ERD

database diagramming

information engineering (IE)

Internet

Visio

attributes

alternate key

building models

Customer and Invoice entity

descriptive information

descriptive metadata

domain (See see Domains)

final graphical model

foreign key

graphical model

identification, information

identifiers (See See Identifiers)

list of names

locators

naming

primary key

transformed, normalization process

values

best practices

business rules

client management

conceptual model

database design

descriptive information

basic set

documentation process

maintenance

scope

storage

documentation

EmployeeRelationship

entity

abbreviations

audit trails

dependent

document

events

foreign key

group

Hungarian notation

ideas

identification

independent

invoiceNumber

list of preliminary entities

logical naming

naming database objects

objects

Pascal/mixed case

people

places

primary key

records and journals

singular/plural names

fundamental process

graphical nature

IDEFIX

initial relationship documentation

logical model

additional data needed

analysis paralysis

client review

customer agreement

many-to-many relationship

objectives

one-to-N relationship
association

Is-A relationship

multivalued attribute

relational model

transaction

relationship

cardinality

graphical representation

identification

many-to-many

migrated key

nonidentification

recursive

role name

subtypes

types

verb phrases

requirements

Data obfuscating

Data protection

check constraints (see Check constraints)

concurrency

custom front-end tools

database-engine level

data formatting

DML triggers (see Data Manipulation Language triggers)

generic data manipulation tools

nvarchar(20) column

raw queries

reliability and integrity

routines

UNIQUE constraint

Date datatype

Date dimension

entity representation

IDENTITY column

standard attributes

stored procedure

table creation

unknown rows

datetime

datetime2(N) datatype

datetimeoffset

dbo.doAnything procedure

dbo schema

DDL. See Data definition language

DDL triggers

decimal datatype

Delimited identifiers

Denormalization

Dependency

entire key

independent multivalue

partial key

between rows

surrogate keys effect

DoorCount

driversLicense and employee tables with natural keys

driversLicense and employee tables with surrogate keys

driversLicense table

GrandparentId

Grandparent table

key migration

Parent table

StateCode

VehicleTypeId

DesiredModelLevel

Development Studio

DisabledFlag

DistributionDescription

Domain: domain1.com

Domain implementation

collation selection

column/table

consistency

datatype selection

approximate numeric data

binary data

boolean/logical values

character (or string) data

complex datatypes

date and time

deprecated/bad choice types

heirarchyId

large-value datatype columns

messaging system model

MessagingUser table

precise numeric data

rowversion

spatial types

sql_variant

uniqueidentifier

user defined type/alias

UserHandle

varchar(N)

varchar(max) column

XML

documentation

ease of implementation

logical modeling

nullability selection

SurrogateKey

TopicName

userHandle

Domains

consistent model

definition

GUID value

logical modeling

modeling, automated tool

standard

subclasses

type

types of person

driversLicenseNumber (driversLicense)

driversLicenseStateCode

driversLicenseStateCode (driversLicense)

EAV. See Entity-attribute-value

Education

EmailAddress

EmailAddressNumber

employeeNumber

Encapsulation

EndDate

Entity-attribute-value (EAV)

dynamic statement

EquipmentPropertyType table creation

EquipmentType column

property schema

property table

row insertion

sql_variant column format

trappable error

Entity-relationship (E-R) modeling method

errorHandlingTestId

Error logging procedure

ExampleModel

EXCEPT relational operator

Extended DDL utilities

EyeColor

Filestream storage

FirstName

First Normal Form

column names with numbers at end

string data with separator-type characters

tables with no/poorly-defined keys

float(N) datatype

fromMessgingUser

GameInstance

GamePlatform

Game tables

GloballyUniqueIdentifier (GUID)

key

value

GrandparentName

heirarchyId

Hierarchies

hierarchyTypeId type

query optimizations

Kimball helper table

nested sets

path technique

self-referencing relationship

graphs

trees (see also Single-parent hierarchies)

Highly recognized abbreviations

Identifiers

candidate keys

Downtown Office

element

Office entity

Patient entity

people’s name

IDENTITY property

Indexes

clustered indexes

ALTER INDEX REORGANIZE

clustering key

equality and inequality

GUID

NEWSEQUENTIALID() function

OLTP setting

range queries

scan

SET STATISTICS IO

creation

dynamic management view queries

fragmentation

index utilization statistics

missing indexes

foreign keys

domain tables

indexed views

many-to-many resolution table relationships

OLTP database

one-to-one relationships

ownership relationships

sample relationship

siteClickLog table

lookup

Management Studio

nonclustered indexes

abstract representation

AVG_RANGE_ROWS

clustered tables

columnstore index

composite indexes

covering indexes

CREATE TABLE testIndex

DBCC SHOW_STATISTICS command

DELETE operation

DISTINCT_RANGE_ROWS

dynamic management views

EQ_ROWS

filtered index

heap

histogram

index keys, sort order

INSERT operation

leaf page

multiple indexes

pointer

ProductId column

profiler

queries density

query processor

RANGE_HI_KEY

RANGE_ROWS

row locator

sample index

SELECT operation

slow queries

TABLESAMPLE clause

UPDATE operation

User lookups

User scans

User seeks

User updates

rules

scan

seek

SET SHOWPLAN_TEXT ON statement

structure

unique indexes

INSTEAD OF triggers

applications

perform action comment (insert symbol in word file)

DBMS

error handler

formatting user input

FormatUpper value

insert statement

multi-row operations

no action on table

redirecting invalid data

RowCreatedTime and RowLastModify time values

SCOPE_IDENTITY() function

UPDATE statement

int datatype

Integration Definition for Information Modeling (IDEFIX)

InvoiceAmount

Isolation levels

application locks

data consistency

definition

hypothetical code snippet

nonrepeatable reads

phantom rows

READ COMMITTED

READ COMMITTED SNAPSHOT

READ UNCOMMITTED

REPEATABLE READ

REPEATABLE READ isolation level

SERIALIZABLE

SNAPSHOT

SNAPSHOT isolation level

syntax

sys.dm_exec_sessions

IsSpecialSale

Key implementation

alternate keys

constraints

logical model

Message table

MessageTopic table

messaging model

MessagingUser table

PartID

PartNumber

TopicId

UserDefinedTopicName column

primary key

existing columns

new surrogate value

Kimball helper table

Large-value datatype columns

LastName

Logs.Call

Manufacturer table

Messages.Message table

MessageTime

MessageTopic table

MessagingUser

MessagingUserId columns

MessagingUser table

MiddleName

Migrated key

MovieRentalPackage table

Multiparent hierarchies

Multiple active result sets (MARS)

nchar, nvarchar, nvarchar(max) datatype

Nested sets

Nonnatural primary keys

DDL, tables building

default constraint

IDENTITY property

manual management

Normalization

BCNF

dependency between rows

entire key dependency

forms

multiple columns with same prefix

partial key dependency

positional meaning

process

relational database system

repeating groups of data

Second Normal Form

SQL

summary data

surrogate keys effect, dependency

DoorCount

driversLicense and employee tables with improper normalization

driversLicense and employee tables with natural keys

driversLicense and employee tables with surrogate keys

driversLicense table

GrandparentId

Grandparent table

key migration

Parent table

StateCode

VehicleType

VehicleTypeId

table and column shape (see Tables)

tables with multiple meanings

Fifth Normal Form

Fourth Normal Form

Third Normal Form

T-SQL

Nullability

Numbers table

additional attributes

comma delimited items separation

D5 and D6 tables, code break

definition

DivisibleByNineFlag

DivisibleBySevenFlag

EXECUTE and SELECT clause

integer cubed calculation

non-negative integers

numbers boundary

precalculated and stored number sequence

SELECT clause multiplier

sequence gaps determination

string content determination

sum of cubes

taxicab numbers

tempdb space

WHERE condition

Object relational mapping (ORM) tools

OptInFlag

Parallelism

ParentName

Pascal-cased names

Patterns

data-driven design

hierarchies (see Hierarchies)

images, documents, and other files

AccountFileDirectory

API

binary data

binary format data storage

binary storage, SQL Server’s storage engine

CREATE TABLE TestSimpleFileStream

customer table with picture

directory creation

DIRECTORY_NAME parameter

encryption

files location

filestream access

filestream attribute

filestream column

filestream data

filestream files

filetable access

FILETABLE_DIRECTORY

filetable directory in Windows Explorer

FileTableRootPath() function

filetable style

generalization

image and data backup

MovieRentalPackage table with PictureUrl datatype

MSSQLSERVER

NON_TRANSACTED_ACCESS

path reference, file data

Remote Blob Store API

ROWGUIDCOL property

security

size

SQL tables

stream_id

transactional integrity

unstructured file data

User-specified data storage (see User-specified data storage)

utilization

varbinary(max) column

uniqueness (See Uniqueness, patterns)

Patternsdata-driven design

Patternsgeneralization

Patternshierarchies

Patternsimages, documents, and other files

Patternsstoring user-specified data

Patternsuniqueness

PersonId

PersonName

PersonNumber

PersonSocialSecurityNumber

Physical database structure

allocation map

bulk changed map

CREATE INDEX command

data pages

data row

datatype-level compression

dictionary compression

differential changed map

extents

files and filegroups

ALTER TABLE statement

COLLATE database_default

CONCAT function

database storage organization

default filegroup

DROP_EXISTING setting

FILEGROWTH parameter

hyperthreading

I/O load distribution

primary files

secondary files

sys.filegroups catalog view

index allocation and data

logical level

mixed extent

overflow data and page

page compression

page free space

page splits

partitioning

physical level

prefix compression

row compression

table data

uniform extent

Physical Data Independence rule

Physical model implementation

adding implementation columns

database generation tools

database requirements

datatype and nullability

DDL (See Data definition language (DDL))

Developer Edition SQL Server

document and script

domain implementation (See Domain implementation)

Enterprise Evaluation Edition SQL Server

foreign key constraints

key implementation (See Key implementation)

logical database design

name selection

delimited identifiers

fred]olicious

identifiers

model name adjustments

naming columns

naming tables

policy-based management

regular identifiers

sysname

normalization maintanance

procedure

real strategy for naming objects

schemas

SQL Server Express

structure testing

CATCH block

delete statements

foreign key constraints

integration testing

MessageTime

MessagingUser table

non-alphanumeric character

RAISERROR statement

RoundedMessageTime

semi-significant issues

six-table database

Sourceforge

test scripts

user defined topic

user handle

tables and columns documentation

Message

MessageTopic

Topic

User

UserConnection

template domains

test script

UNIQUE constraint

PledgeAmount

Policy-based management

Precise numeric data

decimal values

float and real datatypes

money types

SET NUMERIC_ROUNDABORT ON

testvar decimal

integer values

bigint

int

smallint

tinyint

PreferredCustomerFlag

PreferredCustomerIndicator

Primary key

existing columns

new surrogate value

advantages

disadvantages

human-accessible key

IDENTITY property

messaging Database Model

MessagingUser table

ORM tools

otherColumnsForAltKey

parentKeyValue

single-column key

UNIQUE constraint

Primary key (PK)

Primary limiting factor

productNumber

ProductPrice column

Profiler

Pronounced abbreviations

PublisherLocation

PublisherName

PurchaseOrderNumber

Ralph Kimball’s approach

Range uniqueness

appointment

appointmentId

bad row removal

data testing qurey

delete operation

doctorId number

improper data situation

table creation

real datatype

Recursive algorithm

Regular identifiers

Relational database design

binary relationship

cardinality

Codd’s rule, RDBMS

comprehensive data sublanguage

distribution independence

dynamic online catalog

guaranteed access

high-level insert, update and delete

information principle

integrity independence

logical data independence

nonsubversion rule

NULL values

physical data independence

view table

database-specific project phase

conceptual

fundamental techniques

logical

physical

storage

data structure

dependency

determinants

functional

entity relationship

foreign key

history

many-to-many relationship

nonbinary relationship

one-to-exactly N relationship

one-to-many relationship

parent and child tables

relational programming

SQL standards

structure recognition

databases and schemas

domain definition

key (see Candidate key)

metadata storage

missing (NULL) values

tables, rows and columns (see Tables)

Reporting design

aggregation querying

indexing

queries

analytical querying

indexing

queries

requirements-gathering process

styles

aggregation reporting (see Aggregation reporting style)

analytical reporting. (see Analytical reporting style)

innies and outties, definition

Request for proposal (RFP)

Request for quote (RFQ)

Resource Governor

Reusable standard database components

calendar table (see Calendar table)

error logging procedure

numbers table

additional attributes

comma delimited items separation

D5 and D6 tables, code break

definition

DivisibleByNineFlag

DivisibleBySevenFlag

EXECUTE and SELECT clause

integer cubed calculation

non-negative integers

numbers boundary

precalculated and stored number sequence

SELECT clause multiplier

sequence gaps determination

string content determination

sum of cubes

taxicab numbers

tempdb space

WHERE condition

OLTP style load

reference/demographic information

security

universal data models

user-defined functions

utility objects

extended DDL utilities

monitoring tools

SQL Server

temp usage

Reverse cascade operation

RoundedMessageTime

RowCreateTime

RowLastUpdateTime

ROW_NUMBER() windowing function

rowversion datatype

Sales table

SaveTime

Scalar datatype

approximate numeric data

binary data

binary length

image

varbinary length

varbinary max

bit

character strings

char length

nchar, nvarchar, ntext

text

varchar length

varchar max

cursor

date

date functions

date ranges

date representation, text formats

datetime

datetime2

datetimeoffset

non-scalar types

precise numeric data (see Precise numeric data)

rowversion

smalldatetime

sql_variant

table valued parameters

table variables

time

uniqueidentifier

SCOPE_IDENTITY()

Selective uniqueness

customerSettings table

duplicate values

error messages

EXISTS query

filtered index

human resources employee table

indexed views

initial sample row creation

insurancePolicyNumber

NULL

policy numbers

primaryContactFlag

row with ‘fred,’

two rows with null

SELECT SCOPE_IDENTITY()

SentToUserHandle

Server and database audit

audit configuration

audit trail

queue mechanisms

service broker queues

specification

SQL server audit

structure

ShippedToEmailAddress

Single-parent hierarchies

adjacency list

children position

circular references

demonstration company hierarchy

functional language

parents of rows

procedural language

query code, children

recursive type query

single-instance-at-a-time access

table creation

tree structure searched depth first

tree structure with levels

Slowly changing dimension

isCurrent flag

Member dimension table

preferred query

Provider dimension table

rejected query

start date and end date

types

smalldatetime

smallint datatype

Smart keys

Snapshot fact

Snowflake dimension

Sorta Preferred Customer

Spatial datatype

SpecialSaleFlag

SQL server audit

SQL Server code

stored procedures

CATCH block

doomed transaction

error

error handling

object_name function

RAISERROR

ROLLBACK TRANSACTION statement

savepoint

schema

THROW statement

triggers

SQL Server Management Studio

SQL-86 standard

SQL_variant datatype

StoreId

Structure English Query Language (SEQUEL)

SUBSTRING function

SurrogateKey domain

SYNDATETIME() function

sysname

Tables

atmonic values

atomic columns

column names with numbers at end

complex datatypes

data-protection schemes

different rows

e-mail addresses

names

same rows values

string data with separator-type characters

tables with no/poorly-defined keys

telephone numbers

basic data representation terms

column term breakdown

Excel table

First Normal Form

information storage

record manager

relational theory

requirements

row term breakdown

scalar value

Text

TickerCode

time datatype

timestamp datatype

tinyint datatype

Tools.DivisibleByNineAndSevenNumber table

TopicName

Topic table

Transaction fact

bank transaction

Claim Payment fact table

degenerate dimensions

foreign keys

preferred query

rejected query

Transact-SQL (T-SQL)

brute force algorithm

CLR (see CLR)

comma-delimited value

DBAs

flow language

GREATEST function

guidelines

.NET language

SELECT clause

tempdb object

time compiler

Transparent data encryption (TDE)

T-SQL. See Transact-SQL

Type dimension

TypeOfAttendee

Unified Modeling Language (UML)

uniqueidentifier datatype

Uniqueness, patterns

approximate

bulk

baseplate types

bricks types

BuildInstance

BuildInstancePiece

CTE

data loading

grouping sets

InventoryAdjustment Quantity

InventoryAdjustment table

inventory and utilization storage

inventory model

Lego^® collection

minimal builds

personal inventory

Piece

Piece table

ProductSale Quantity

row constructor syntax

rows and data manipulation

sample Lego parts

table creation

table implementation

types of pieces

range

appointment

appointmentId

bad row removal

data testing qurey

delete operation

doctorId number

improper data situation

table creation

selective

customerSettings table

duplicate values

error messages

EXISTS query

filtered index

human resources employee table

indexed views

initial sample row creation

insurancePolicyNumber

NULL

policy numbers

primaryContactFlag

row with ‘fred,’

two rows with null

types

User-defined functions (UDF)

UserDefinedTopicName

User-defined types (UDTs)

UserHandle

UserId

User interface (UI)

UserName

User-specified data storage

adding columns to table

ALTER TABLE

CHECK constraint

column set

HammerHeadStyle

invalid value error

Length column

non-administrative users

normal UPDATE statement

primary key

SELECT statement

sparse columns

big old list, generic columns

EAV

dynamic statement

EquipmentPropertyType table creation

EquipmentType column

property schema

property table

row insertion

sql_variant column format

trappable error

Equipment table

methods

T-SQL flexibility

varbinary(max) datatype

varbinary(N) datatype

varchar(max) datatype

varchar(N) datatype

VehicleBrand

VehicleStyle

Waterfall method

Website-linking system

XML

datatype

hierarchyId