Index
A
Accent sensitivity
Advantages
configuration data
ORM
performance
reduce operator intervention
search boxes
WHERE clauses
AdventureWorks
Aggregate function
Application traffic, scanning
Archiving/movement of data
database log data
data size, increase
dynamic SQL
Log_Time
new databases
new tables
reference points
tasks
TSQL
Auditing users and logins
list, mappings
object-level permissions
script, user-created securables
server logins and roles
TSQL to return relationships
Audit password policies
B
Backup software
BACKUP statements
Batched command string creation
Blind SQL injection attacks
Built in function
Bushy query tree
BusinessEntityContact table
Business logic, complex
C
Cardinality
back to dynamic SQL
statistics (
see
Statistics)
sys.dm_db_stats_properties
trace flag 2371 ...
Get Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server 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.
