Index
A
datedimension See Date dimension
health care payer dimensional model
B
C
complex procedural logic and computations
string manipulation, complex statistical calculations and custom encryption
D
host server security configuration
object-relational mapping tools
fine-tuning without program changes
mutable business logic and rules
sp_executeSQL and parameterization
application layer control security
controlling access to data via T-SQL coded objects
Data definition language (DDL)
[WITH CHECK | WITH NOCHECK] specification
triggers, maintain automatic values
Descriptions in Management Studio
fn_listExtendedProperty object
tables, column, and schemas limitations
non-natural primarykeys See Non-natural primary keys
databases and servers relationship
ErrorHandling.ErrorLog$insert object
E
F
G
H
I
dynamic management view queries
many-to-many resolution table relationships
J
K
L
M
N
O
P, Q
binary storage, SQL Server’s storage engine
CREATE TABLE TestSimpleFileStream
DDL See Data definition language (DDL)
domainimplementation See Domain implementation
key implementationselection See Key implementation
R
S
T
Trigger. See also AFTER triggers; INSTEAD OF triggers
ErrorHandling .ErrorLog$insert object
U
V
W, X, Y, Z