Index
A
Adaptive joins
Automatic database tuning
index management
plan correction
query store
B
Binary strings
Buffer pool
C
Clustered Index Scans
Clustered Index Seek
Coding standards
database design
ANSI standard
constraint
foreign keys
non-clustered indexes
normal forms
primary keys
table size
value pair, name
performance
implicit conversion
NOLOCK
NULL values
RECOMPILE
sargeable
select data
SET NOCOUNT ON
usability
BETWEEN
CASE statement
CAST
columns
cursors
linked servers
ORDER BY statement
stored procedure parameters
TRY… CATCH
UNION statement
Commenting
header
non-standard practices
queries
stored procedure
view
Common table expressions (CTE)
creation
execution plan
query
recursive CTE
Complex logic
comments
Dynamic Cursor, creation
header information
output, cursor
parameters
query, avoid cursor
query, pull back
SQL Server
CPU server
execution plan
fragmentation
hardware
implicit conversion
I/O
MAXDOP
parallelism
SQL server
T-SQL queries
Cursors
data type
forward-only
dynamic cursor
example
execution plan
keyset cursor
output
static cursor
D
DACPACs
Data definition language (DDL) triggers
Data manipulation language (DML) triggers
creation
execution plans
instead action
INSTEAD OF trigger
query
updated statement
Data sets
add new record
code writing
SeeData sets code
creation
dbo.Recipe table
individual records
ingredient table
insert data records
insert multiple records
search, Ingredient Name
SELECT statements
updated records
Data sets code
delete data
ingredients data
ingredients Union
insert data
queries, except
queries intersection
record by record insertion
Select statement
Union All
union, two queries
update
as data set
join tables
as range
record by record
Date and time data types
DATE
DATETIME
DATETIME2
DATETIMEOFFSET
SMALLDATETIME
TIME
DATEPART function
Deployment
automate
application and database
DACPACs
database changes
feature flags, remove
original application, remove
state-based migration approach
T-SQL code
unmodified application and database
feature flag
enable flag
functionality
insert record
solutions
stored procedure
table creation
methodology
migration-based approach
rollback strategy
SQL Server
T-SQL code
workflows
E
Execution plans
index usage
clustered index
Clustered Index Scans
Clustered Index Seek
Key Lookup
non-clustered index
RID Lookup
table scan
logical join types
Concatenation
Full Outer Join
Hash Match
merge Join
nested loop
RecipeID
RecipeIngredient
RecipeIngredientID
RIGHT SEMI JOIN
UNION
reading
actual number of rows
arrows
graphical execution
properties
Sort operators
sys.dm_exec_cached_plans
warning
XML format
F
Filegroups
Formatting
aliasing
ANDs or ORs
capitalization
COMMIT
common table expression
cursor
delete data
DELETE statement
DML trigger
function
insert data
ORDER BY statement
query
joins
subqueries
ROLLBACK
SELECT statement
table-valued parameter
table variable
temporary table
update data
user-defined table
view
WHERE clause
G
Git
H
HIERARCHYID data type
Hybrid workloads
access data
Clustered Index Scan
Clustered Index Seek
execution plan
non-partitioned table
partitioned table
partitioned views
unpartitioned table
I, J, K
Indexed view
Integration testing
data warehouse
definition
inactive/active recipes
insert record
manual
recipe & ingredient
stored procedures
Intelligent query processing
adaptive joins
live query statistics
properties
query, specific recipe
query statistics
index management
memory grants
Rowstore
L
Load testing
Logging
data modification
cdc.dbo_Recipe_CT
changed records, find
data capture, dbo.Recipe
dbo.Recipe table, tracking
insert records
Menu database, tracking
query initialized records
SQL Server Audit
tracking database
tracking result set
update
error handling
recipe history status
TRY… CATCH block
Logon triggers
M
Memory
ad hoc queries
buffer pool
caching
logical reads
OLTP
query
RAM
SSDs
Migration-based deployment method
N
Naming
clustered index
database objects
foreign key
non-clustered index
Object Explorer
primary key
queries
stored procedure
tables
Non-clustered indexes
Normal form
Number data types
approximate
converting
exact
BIGINT
BIT
DECIMAL/NUMERIC
INT
MONEY
SMALLINT
SMALLMONEY
TINYINT
O
Online transaction processing (OLTP)
Optimization
duration
adaptive Join
execution plan
recipes
SQL Server
sys.dm_exec_query_stats
T-SQL statements
local reads
advantage
dbo.RecipeIngredient
DMVs
execution plan
IsActive flag
non-clustered index
queries
recipe and preparation details
sys.dm_exec_sql_text
P, Q
Parallelism
Parameters, designing
ad hoc query
Plan Cache, comparison
SELECT statement
stored procedure
creation
execution
hard-coded value
records
sniffing
variable
Partitioned tables
access data
add partition
clustered index
Clustered Index Scan
creation
data
data growth
data structure
execution plan
unpartitioned table
full scan
non-clustered primary key
non-partitioned table
partition scheme
partition switching
query results
range function
RecipeHistFunc.
RecipeHistoryID
RecipeHistRange
row counts
view partitions
Partitioned views
access data
Clustered Index Seek
constraints
create tables
creation
date range
execution plan
limit table access
UNION ALL
Partitioning
dbo.RecipeHistory table
definition
filegroups
indexes
key
left range
new partition
partition column
partition elimination
partition function
partition scheme
right range
SQL Server
Partition switching
R
Relational database management system (RDBMS)
Rollforward strategy
ROWVERSION data type
S
Scalar functions
code
compatibility mode
compatibility mode 140
compatibility mode 150
CPU and elapsed times
execution plans
multi-statement scalar UDF
scalar UDF
Set-based design
data record row
data retrieval
data set
group data
hybrid buffer pool
procedural code
SQL Server
types of data
Solid state drive (SSDs)
Sort operators
Source control
advantage
conflict
database
Git
rollforward strategy
setting up
database projects
GitHub actions
Git repository, create
local Git repository
message confirmation
SQL Server connect
Synchronization submenu
Team Explorer
third-party tools
Visual Studio control
stored procedure
TFS
T-SQL scripts
Spatial geography data types
Spatial geometry data types
SQL Server Reporting Services (SSRS)
SQL_VARIANT data type
State-based migration approach
Static code analysis
Storage
bottlenecks
buffer pool
cost
data
data access
engine
index
tempdb
transaction log
Stored procedures, designing
ad hoc query logic
ad hoc query, modified
creation
execution plan
plan cache
SQL Server
String data types
BINARY
character
CHAR
TEXT
VARCHAR
IMAGE
unicode
NCHAR
NTEXT
NVARCHAR
VARBINARY
T
Table data type
Table-valued functions
inline
creation
execution plan
query
UDF
multi-statement
code
compatibility mode 110
compatibility mode 110vs . 140
compatibility mode 110vs . 140vs . 150
compatibility mode 140
compatibility mode 150
creation
CROSS APPLY
optimization process
Table-valued parameters
code
example
execution plan
set-based operations
stored procedures
Table variables
Team Foundation Server (TFS)
Temporary stored procedures
Temporary tables
global
local
persistent
Triggers
DDL
DML
logon
U, V
UNION or UNION ALL option
UNIQUEIDENTIFIER data type
Unit testing
active recipes
code
concept
connection string
creation
definition
dialog box
Empty ResultSet
fail
implementations
inactive recipes
pass
recipes
records
run
source control
stored procedure
test conditions
tools
User-defined function (UDF)
User-defined table types
User-defined view
ad hoc query
alter view
calling
creation
definition
execution plans
insert data
query
remove column
schema binding
update data
W
WITH RECOMPILE query
X, Y, Z
XML data type
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.116.118.245