Transact-SQL Cookbook
| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]
AccountPermissions table new permissions activity logging reporting row-level logs comparison activity-level logging recipe aggregates classes, summarizing hierarchies revised procedure nonaggregated columns recipes running aggregate query arithmetic mean, statistics arrays example joins, master tables printing rows, comparing tables, joining ASCII chart, Pivot table and ASCII files importing importing with BULK INSERT statement attributes normalized data status attributes, permissions audit logs activity logging database tables event reconstruction global logs information access local logs objectives online account-balancing recipe operating system files records row-level logging space used, minimizing storage units triggers warehouse example authorization logic, centralizing queries, embedding autocorrelation patterns and statistics averages, statistics exponential moving averages 2nd weighted averages AVG function
|