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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.