Microsoft® SQL Server® 2012 Bible

1367 Index Operational Channel, 941 operational database, 21 operators bitwise, expressions, 179–181 comparison, 121 Extended Ev ...

1368 Index partitions (cont inued) creating, 1122–1123 indexes, 1128 performance, 1117 queries, 1123 switching, 1125–1127 vertic ...

1369 Index object cmdlets, 775 PATH, 769 PerfMon, 914–917 $profile, 786 Registry, 782 scripts, 769–799 ADO.NET, 790–792 blocks, ...

1370 Index Query Editor bookmarks, 102 connecting query to server, 99 connection bar, 100 data modifi cation, 292 deadlocks, 106 ...

1371 Index relational algebra/logical design, 145, 213 relational database design, 143–171 cardinality, 152–153 columns, 145–146 ...

1372 Index Restore-SqlDatabase, 784 restrict, in relational algebra, 213 restricted_user, 524 result sets, 78 aggregate function ...

1373 Index ScrappedReasonID, 1035 scripts blocks, PowerShell, 776 Database Designer, 620 database transfer, 620–624 PowerShell, ...

1374 Index Server Audit Specifi cation create, 972 Object Explorer Security, 91 SQL Audit, 971–973 SSMS, 972 T-SQL, 972 Server A ...

1375 Index RESTORE DATABASE, 643–644 rolling back, 643–645 using, 638–645 Windows Explorer, 640 isolation, 79, 1082–1085 replica ...

1376 Index SQL Profi ler (cont inued) selecting, 921–923 Events Selection, 921 execution plans, 996, 999–1000 Extended Events, 9 ...

1377 Index log shipping, 683 MDW, 978 metadata, 1177 Object Explorer, 92 ODBC, 1157 OLE DB, 1157 Package Deployment Model, 1188– ...

1378 Index SQL Server Reporting Services (SSRS) (cont inued) layout, 1251–1255 Report Wizard, 1237–1239 reports, 1233–1259 deplo ...

1379 Index nested, 241 in relational algebra, 214 scalar, 240–241 simple, 237–241 SOME, 241–244 tables, 242 Q (theta) joins, 231 ...

1380 Index tables. See also common table expressions (cont inued) switching, 1125–1127 physical schema, 24 Power View, 1334 quer ...

1381 Index rollback, DDL triggers, 906 save points, 1054 SELECT, 1049–1050 SQL Profi ler, 922 triggers, 880–881, 886–891 UPDATE, ...

1382 Index truncate table, 949 TRUNCATEONLY, 601 TRY...CATCH deadlocks, 1064 INSERT, 313 nested, 423–424 RAISERROR, 450 transact ...

1383 Index PowerShell, 772 queries, 397 scope, 393–394 SELECT, 393–395 SET, 394–395 SSIS, 1160 Control Flow, 1172 SSIS Designer, ...

1384 Index WHILE BEGIN/END, 401 BREAK, 402 CONTINUE, 402 T-SQL, 82, 401–402 While, PowerShell control fl ow command, 774 wildcar ...