Index
A
- ACID characteristics
- Activity Monitor
- ad hoc workloads
- aggregate functions
- alias data types
- ALTER DATABASE statement
- ALTER PROCEDURE statement
- ALTER VIEW statement
- analytic window functions, T-SQL
- application programming interfaces (APIs) / The CREATE VIEW statement
- architecture, columnstore indexes / The architecture of columnstore indexes
- arguments, ALTER DATABASE statement
- arguments, CREATE DATABASE command
- arguments, CREATE FUNCTION statement
- arguments, CREATE PROCEDURE statement
- arguments, CREATE VIEW statement
- arguments, DELETE statement
- arguments, INSERT statement
- arguments, MERGE statement
- arguments, UPDATE statement
- atomic, consistent, isolated, and durable (ACID) / Creating and managing tables
- atomicity
- attribute
- attributes, procedure_option
- attributes, WITH <function_option>
- attributes, WITH view_attributes
- autocommit transaction mode / Transaction modes
- AUTO_CREATE_STATISTICS statement
- AUTO_UPDATE_STATISTICS statement
- AUTO_UPDATE_STATISTICS_ASYNC statement
B
- balanced tree (B-tree)
- batch-scoped transaction mode / Transaction modes
- BEGIN TRANSACTION statement
- BEGIN
END keywords
- BETWEEN operator
- binding
- blocked processes
- BREAK statement
- bulk-logged recovery model / The bulk-logged recovery model
- bulk update locks (BU)
C
- cardinality
- cardinality estimator
- CASE statement
- categories, data integrity
- change data capture (CDC) / The msdb database
- characteristics, transactions
- clauses, T-SQL
- CLR stored procedures
- CLR triggers
- CLR user-defined function
- CLR user-defined types
- clustered indexes
- clustered indexes, on table
- columnstore indexes
- column_list parameter / Inserting data into SQL Server database tables
- COMMIT TRANSACTION statement
- components, SQL Server Database Engine
- composite indexes
- conceptual design phase, database design process / The conceptual design phase
- configuration functions
- consistency
- CONTINUE statement
- control-of-flow keywords
- about / Control-of-flow keywords
- BEGIN
END / BEGIN…END keywords
- IF
ELSE expression / The IF…ELSE expression
- CASE statement / A CASE statement
- WHILE / WHILE, BREAK, and CONTINUE statements
- BREAK / WHILE, BREAK, and CONTINUE statements
- CONTINUE / WHILE, BREAK, and CONTINUE statements
- RETURN / RETURN, GOTO, and WAITFOR statements
- GOTO / RETURN, GOTO, and WAITFOR statements
- WAITFOR / RETURN, GOTO, and WAITFOR statements
- covering indexes
- CREATE DATABASE command
- CREATE FUNCTION statement
- CREATE INDEX statement
- CREATE PROCEDURE statement
- CREATE STATISTICS (Transact-SQL) article
- CREATE STATISTICS statement
- CREATE TABLE (SQL Server) article
- CREATE TYPE
- Create View pane
- CREATE VIEW statement
- CROSS JOIN operator
- CTE
- CUME_DIST function
- cursor functions
- cursor variable
D
- data
- database
- database-wide statistics options, SQL Server
- database administrator (DBA) / Indexes
- database administrators (DBAs)
- database design process
- database files, SQL Server
- Data Definition Language (DDL) / The implementation and loading phase
- data flow diagrams (DFDs)
- data integrity
- Data Manipulation Language (DML) / Pages
- data type
- data types, SQL Server
- date and time functions
- DBCC SHOW_STATISTICS command
- DCL statements
- DDL
- DDL trigger
- DDL triggers
- DECLARE statement
- DELETE statement
- denormalization
- DENSE_RANK function
- Devent classes, SQL Server Profiler
- dirty reads
- DISTINCT clause
- distribution database / The distribution database
- DLL
- DML statements
- DML triggers
- DML triggers, types
- domain integrity
- DROP TYPE
- DROP VIEW statement
- durability
- dynamic lock management / An overview of locking
- Dynamic Management Views (DMVs)
E
- entities
- entity-relationship (ER) model
- entity integrity
- EVENTDATA function
- examples, DELETE statement
- examples, INSERT statement
- examples, MERGE statement / The MERGE statement examples
- examples, T-SQL DDL statements
- examples, TRUNCATE TABLE statement / The TRUNCATE TABLE statement
- examples, UPDATE statement
- EXCEPT operator
- exclusive locks (X)
- EXEC statement
- EXISTS keyword
- explicit transaction mode / Transaction modes
- extended user-defined stored procedures
- extent
F
- features, unique indexes / Unique indexes
- fifth normal form (5NF)
- filegroups
- file tables / Creating and managing tables
- filtered indexes
- first normal form (1NF)
- FIRST_VALUE function
- forth normal form (4NF)
- FROM clause
- full-text indexes
- FULL OUTER JOIN operator
G
H
I
- IDENTITY column
- IF
ELSE expression
- implementation and loading phase, database design process / The implementation and loading phase
- implicit transaction mode / Transaction modes
- in-memory-optimized tables
- in-memory OLTP engine
- in-memory optimized OLTP tables
- in-memory optimized tables
- included columns
- index
- index, types
- indexed views
- indexes
- index fragmentation
- inline table-valued function
- INNER JOIN operator
- IN operator
- INSERT statement
- intent exclusive (IX) lock / Basic locks
- intent locks
- intent shared (IS) lock / Basic locks
- INTERSECT operator
- IS NOT operator
- isolation
- IS operator
J
L
M
N
- natively compiled stored procedures
- nested triggers
- nonclustered columnstore index
- nonclustered indexes
- nonrepeatable reads
- normal forms
- normalization
- NOT EXISTS keyword
- NOT IN operator
- NTILE function
O
P
Q
- query execution
- query optimization
- query optimization process
- query optimization statistics
- query plan aging
R
S
- SAVE TRANSACTION statement
- scalar functions, within CATCH block
- schema
- schema locks
- SCHEMA_AND_DATA in-memory optimized OLTP tables
- SCHEMA_ONLY in-memory optimized OLTP tables
- Search Arguments (SARG)
- secondary data file / The SQL Server database architecture
- second normal form (2NF)
- securables
- security functions
- SELECT INTO statement
- SELECT statement
- select_list parameter / The SELECT statement
- self joins
- SERIALIZABLE transaction isolation level / Transaction isolation
- Server 2014 system databases
- service-level agreement (SLA) / Indexes
- SET keyword
- shared locks (S)
- shared with intent exclusive (SIX) lock / Basic locks
- simple recovery model / The simple recovery model
- single-column indexes
- SNAPSHOT transaction isolation level / Transaction isolation
- spatial indexes
- Specify Fill Factor for an Index article
- sp_who2 system stored procedure / The sp_who and sp_who2 system stored procedures
- sp_who system stored procedure / The sp_who and sp_who2 system stored procedures
- SQL Server
- SQLServer*Locks performance object
- SQL Server 2014
- SQL Server database architecture
- SQL Server Database Engine
- SQL Server database table
- SQL Server database tables
- SQL Server Extended Events
- SQL Server performance
- SQL Server Profiler
- SQL Server query optimizer
- SSMS 2014
- alias data types, creating with / Creating and dropping alias data types with SSMS 2014
- alias data types, dropping with / Creating and dropping alias data types with SSMS 2014
- used, for creating database / Creating a database with SSMS 2014
- used, for modifying database / Modifying a database with SSMS 2014
- used, for dropping database / Dropping a database with SSMS 2014
- used, for managing schema / Managing schemas using SSMS 2014
- used, for creating tables / Creating a table with SSMS 2014
- used, for modifying tables / Modifying a table with SSMS 2014
- used, for deleting tables / Deleting a table with SSMS 2014
- used, for managing permission / Managing permissions using SSMS 2014
- views, creating with / Creating views with Transact-SQL and SSMS 2014, Creating views with SSMS 2014
- views, altering with / Creating, altering, and dropping views with SSMS 2014, Altering and dropping views with SSMS 2014
- views, dropping with / Creating, altering, and dropping views with SSMS 2014, Altering and dropping views with SSMS 2014
- statistics
- STATS_DATE() function
- Storage Engine
- stored procedure
- stored procedures, types
- string functions
- subqueries
- sys.stats catalog view
- system databases, SQL Server 2014
- system data types, SQL Server 2014
- system statistical functions
- system stored procedures
- system tables / Creating and managing tables
T
- T-SQL
- T-SQL DCL statements
- T-SQL DDL statements
- used, for creating database / Creating a database with T-SQL DDL statements
- used, for modifying database / Modifying a database with T-SQL DDL statements
- used, for dropping database / Dropping a database with T-SQL DDL statements
- used, for managing schema / Managing schemas using T-SQL DDL statements
- used, for creating tables / Creating a table with T-SQL DDL statements
- used, for modifying tables / Modifying a table with T-SQL DDL statements
- used, for dropping tables / Dropping a table with T-SQL DDL statements
- views, creating with / Creating, altering, and dropping views with Transact-SQL DDL statements
- views, altering with / Creating, altering, and dropping views with Transact-SQL DDL statements
- views, dropping with / Creating, altering, and dropping views with Transact-SQL DDL statements
- T-SQL errors
- T-SQL functions, in query
- T-SQL statements
- table design
- tables
- table variable
- tempdb database / The tempdb database
- temporary stored procedures
- temporary tables / Creating and managing tables
- testing and evaluation phase, database design process / The testing and evaluation phase
- third normal form (3NF)
- TOP clause
- Transact-SQL DDL statement
- transaction isolation
- transaction isolation levels, SQL Server 2014
- transaction log file / The SQL Server database architecture
- transaction log file architecture
- transaction modes
- transactions
- triggers
- TRUNCATE TABLE statement
- TRY
CATCH block
- TRY
CATCH with RAISERROR block
- TRY
CATCH with THROW block
U
- UNION ALL operator
- UNION operator
- unique indexes
- update locks (U)
- UPDATE statement
- UPDATE STATISTICS (Transact-SQL) article
- UPDATE STATISTICS statement
- user-defined functions
- user-defined integrity
- user-defined scalar function
- user-defined stored procedures
- user-defined table-valued function
- user-defined tables / Creating and managing tables
V
- variables
- Venn diagram
- views
- about / Creating and using views
- creating / Creating and using views
- using / Creating and using views
- uses / Creating and using views
- creating, with T-SQL / Creating views with Transact-SQL and SSMS 2014
- creating, with SSMS 2014 / Creating views with Transact-SQL and SSMS 2014, Creating views with SSMS 2014
- creating, with T-SQL DDL statements / Creating, altering, and dropping views with Transact-SQL DDL statements
- altering, with T-SQL DDL statements / Creating, altering, and dropping views with Transact-SQL DDL statements
- dropping, with T-SQL DDL statements / Creating, altering, and dropping views with Transact-SQL DDL statements
- altering, with SSMS 2014 / Creating, altering, and dropping views with SSMS 2014, Altering and dropping views with SSMS 2014
- dropping, with SSMS 2014 / Creating, altering, and dropping views with SSMS 2014, Altering and dropping views with SSMS 2014
- Virtual Log Files (VLFs) / The transaction log file architecture
W
X
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.