Microsoft® SQL Server® 2012 Bible

1347 Index Symbols , (comma) CTEs, 239, 240 locking hints, 1085 ; (semi-colon) IF, 399 statements, 137 termination, 392 */, comm ...

1348 Index aggregate functions (cont inued) nulls, 252 ORDER BY, 251 ranking functions, 265–266 result sets, 252–256 views, 283 ...

1349 Index hierarchies, 1206–1207 1NF, 165–166 AttributeHierarchyDisplay Folder, 1207 AttributeHierarchyOptimized State, 1207 At ...

1350 Index BLOCKSIZE, 561 body, reports, 1251 BOL. See Books Online bookmarks, Query Editor, 102 bookmark lookup query path, 102 ...

1351 Index data, 945–954 database, 946–947 DMVs, 949 indexes, 949 internal tables, 949–950 PK, 949 queries, 950–953 removing, 95 ...

1352 Index composite indexes, 1010 fi lter by ordered, 1029 fi lter by unordered, 1030 compression. See data compression COMPRES ...

1353 Index default language, 508 output parameters, 445 Azure SQL Database, 812 SQL Profi ler, 922 stored procedures, 433 trigge ...

1354 Index data compression, 1097–1108 ALTER, 1105–1106 backup, 1099 compression, 1098 B-tree, 1100 clustered indexes, 1098 coun ...

1355 Index date/time, 76, 175–176 DECLARE, 393 large value, 78 numeric, 175 PowerShell scripts, 779 SSIS parameters, 1184 variab ...

1356 Index Database Engine (cont inued) server nodes, 90 System Monitor, 911 Tuning Advisor, 11, 1033 SQL Profi ler, 925 Databas ...

1357 Index Delayed Name Resolution, 1042 DELETE, 111, 291, 310–313, 389 FROM, 310–311, 890 ANSI, 311 CTEs, 335 returning data, 3 ...

1358 Index durability. See also atomic, consistent, isolated, and durable recovery, 548, 550 transactions, 1049 transaction logs ...

1359 Index Query Optimizer, 997, 1041–1042 query recompiles, 1044–1045 reading, 997–998 reuse, 1041–1046 SQL Profi ler, 996, 999 ...

1360 Index footer, reports, 1251 For PowerShell control fl ow command, 774 SSIS container, 1170 FOR LET WHERE ORDER BY RETURN (F ...

1361 Index fi lter, 328 IsDescendantOf(), 328–330 methods, 331–334 nodes, 330–331 subtrees, 329–330 ToString(), 327 WHERE, 328 h ...

1362 Index INSERT (cont inued) UPDATE(), 887 views, 283 insert, 97, 873 CDC, 954 nested triggers, 522 inserts data compression, ...

1363 Index in relational algebra, 214, 215–231 SELECT, 215, 217 self, 227–229 Q(theta), 231 T-SQL, 217, 222 WHERE, 215 junction ...

1364 Index logical fl ow query statement, 114–116 SELECT, 116 logical functions, 184–185 logical tables, 888–889 logical transac ...

1365 Index mini-charts, 1254 minimum query memory, 486 minimum server memory, 65–66 Mining Models, Data Mining Designer, 1285–12 ...

1366 Index normalization (cont inued) database extensibility, 18, 148 usability, 17, 148 fi rst-generation data, 21 performance, ...