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 ...
Get Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
