38,99 €
Mehr erfahren.
- Herausgeber: John Wiley & Sons
- Kategorie: Wissenschaft und neue Technologien
- Serie: Bible
- Sprache: Englisch
Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, Microsoft SQL Server 2012 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak. The book is crammed with specific examples, sample code, and a host of tips, workarounds, and best practices. In addition, downloadable code is available from the book's companion web site, which you can use to jumpstart your own projects. * Serves as an authoritative guide to Microsoft's SQL Server 2012 for database administrators and developers * Covers all the software's new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications * Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services * Demonstrates tasks both graphically and in SQL code to enhance your learning * Provides source code from the companion web site, which you can use as a basis for your own projects * Explores tips, smart workarounds, and best practices to help you on the job Get thoroughly up to speed on SQL Server 2012 with Microsoft SQL Server 2012 Bible.
Sie lesen das E-Book in den Legimi-Apps auf:
Seitenzahl: 1767
Veröffentlichungsjahr: 2012
Ähnliche
Contents
Cover
Title
Copyright
Dedication
About the Authors
About the Contributors
About the Technical Editors
Credits
Acknowledgments
Introduction
Part I: Laying the Foundations
Chapter 1: The World of SQL Server
SQL Server History
SQL Server in the Database Market
SQL Server Components
Editions of SQL Server 2012
Notable SQL Server 2012 Enhancements
Summary
Chapter 2: Data Architecture
Information Architecture Principle
Database Objectives
Smart Database Design
Summary
Chapter 3: Installing SQL Server
Preparing the Server
Selecting the Edition
The Installation Process
Summary
Chapter 4: Client Connectivity
Enabling Server Connectivity
SQL Server Native Client Features
Summary
Chapter 5: SQL Server Management and Development Tools
Organizing the Interface
Registered Servers
Object Explorer
Using the Query Editor
Using the Solution Explorer
Getting a Jumpstart on Code with Templates and Code Snippets
Summary
Part II: Building Databases and Working with Data
Chapter 6: Introducing Basic Query Flow
Understanding Query Flow
FROM Clause Data Sources
WHERE Conditions
(0 row(s) affected)Columns, Stars, Aliases, and Expressions
Ordering the Result Set
Select Distinct
TOP ()
Summary
Chapter 7: Relational Database Design and Creating the Physical Database Schema
Database Basics
Data Design Patterns
Normal Forms
Strategy Considerations
Summary
Chapter 8: Data Types, Expressions, and Scalar Functions
Data Types
Building Expressions
Scalar Functions
String Functions
Soundex Functions
Data-Type Conversion Functions
Server Environment Information
Summary
Chapter 9: Merging Data with Joins, Subqueries, and CTEs
Using Joins
Set Difference Queries
Using Unions
Subqueries
Summary
Chapter 10: Aggregating, Windowing, and Ranking Data
Aggregating Data
Grouping Within a Result Set
Windowing and Ranking
Ranking Functions
Summary
Chapter 11: Projecting Data Through Views
Why Use Views?
The Basic View
A Broader Point of View
Locking Down the View
Using SQL Synonyms
Summary
Chapter 12: Modifying Data In SQL Server
Inserting Data
Updating Data
Deleting Data
Merging Data
Returning Modified Data
Summary
Part III: Advanced T-SQL Data Types and Querying Techniques
Chapter 13: Working with Hierarchies
HierarchyID
HierarchyID Methods
Indexing Strategies
Hierarchical Data Alternatives
Summary
Chapter 14: Using XML Data
The XML Data Type
XML Data Type Methods
FOR XML
XQuery and FLWOR Operations
Summary
Chapter 15: Executing Distributed Queries
Distributed Query Overview
Developing Distributed Queries
Performance Consideration
Summary
Part IV: Programming with T-SQL
Chapter 16: Programming with T-SQL
Transact-SQL Fundamentals
Working with Variables
Procedural Flow
Examining SQL Server with Code
Temporary Tables and Table Variables
What's New in T-SQL for 2012
Error Handling
Bulk Operations
Summary
Chapter 17: Developing Stored Procedures
Managing Stored Procedures
Passing Data to Stored Procedures
Returning Data from Stored Procedures
Summary
Chapter 18: Building User-Defined Functions
Scalar Functions
Inline Table-Valued Functions
Multistatement Table-Valued Functions
Best Practices with User-Defined Functions
Summary
Part V: Enterprise Data Management
Chapter 19: Configuring SQL Server
Setting the Options
Configuration Options
Summary
Chapter 20: Policy Based Management
Defining Policies
Evaluating Policies
Summary
Chapter 21: Backup and Recovery Planning
Recovery Concepts
Recovery Models
Backing Up the Database
Working with the Transaction Log
Recovery Operations
System Databases Recovery
Performing a Complete Recovery
Summary
Chapter 22: Maintaining the Database
DBCC Commands
Managing Database Maintenance
Summary
Chapter 23: Transferring Databases
Copy Database Wizard
Working with SQL Script
Detaching and Attaching
Import and Export Wizard
Data-Tier Application (DAC)
Summary
Chapter 24: Database Snapshots
How Do Database Snapshots Work?
Using Database Snapshots
Summary
Chapter 25: Asynchronous Messaging with Service Broker
Configuring a Message Queue
Working with Dialogs
What's New in Service Broker for SQL Server 2012?
Monitoring and Troubleshooting Service Broker
Summary
Chapter 26: Log Shipping
Availability Testing
Warm Standby Availability
Defining Log Shipping
Checking Log Shipping Configuration
Monitoring Log Shipping
Modifying or Removing Log Shipping
Switching Roles
Summary
Chapter 27: Database Mirroring
Database Mirroring Overview
Defining and Configuring Database Mirroring
Checking Database Mirroring Configuration
Monitoring Database Mirroring
Pausing or Removing Database Mirroring
Role Switching
High Availability/AlwaysOn
Summary
Chapter 28: Replicating Data
Moving Data Between Servers
Replication Concepts
Configuring Replication
Summary
Chapter 29: Clustering
What Does Clustering Do?
Configuring Clustering
Summary
Chapter 30: Configuring and Managing SQL Server with PowerShell
Why Use PowerShell?
Basic PowerShell
SQL Server PowerShell Extensions
Communicating with SQL Server via SMO
Scripting SQL Server Tasks
Summary
Chapter 31: Managing Data in Windows Azure SQL Database
Overview of Azure SQL Database
Managing Windows Azure SQL Database
High Availability and Scalability
Migrating Data to SQL Database
Summary
Part VI: Securing Your SQL Server
Chapter 32: Authentication Types in SQL Server
Windows Authentication
SQL Authentication
Differences Between SQL and Windows Authentication
Kerberos and Windows Authentication Delegation
Summary
Chapter 33: Authorizing Securables
Permission Chains
Object Ownership
Securables Permissions
Object Security
A Sample Security Model
Views and Security
Summary
Chapter 34: Data Encryption
Introducing Data Encryption
Summary
Chapter 35: Row-Level Security
The Security Table
Assigning Permissions
Checking Permissions
Summary
Part VII: Monitoring and Auditing
Chapter 36: Creating Triggers
Trigger Basics
Working with the Transaction
Multiple-Trigger Interaction
Transaction-Aggregation Handling
DDL Triggers
Managing DDL Triggers
Developing DDL Triggers
Summary
Chapter 37: Performance Monitor and PAL
Using PerfMon
Summary
Chapter 38: Using Profiler and SQL Trace
Features of SQL Server Profiler
Running Profiler
Using SQL Trace
Summary
Chapter 39: Wait States
The SQL Server OS
Examining Wait Statistics
Common Red-Flag Wait Types
Other Ways to Gather Wait data
Summary
Chapter 40: Extended Events
The Extended Events Object Model
The system_health Session
The Extended Events Profiler
Summary
Chapter 41: Data Change Tracking and Capture
Configuring Change Tracking
Querying Change Tracking
Removing Change Tracking
Change Data Capture
New in SQL Server 2012
Enabling CDC
Working with Change Data Capture
Removing Change Data Capture
Summary
Chapter 42: SQL Audit
SQL Audit Technology Overview
Creating an Audit
Server Audit Specifications
Database Audit Specifications
Viewing the Audit Trail
Summary
Chapter 43: Management Data Warehouse
Using the Management Data Warehouse
Configuring MDW
Setting Up Data Collection
Viewing MDW Reports
Creating Custom Data Collector Sets
Summary
Part VIII: Performance Tuning and Optimization
Chapter 44: Interpreting Query Execution Plans
Viewing Query Execution Plans
Understanding Execution Plan Operators
Summary
Chapter 45: Indexing Strategies
Zen and the Art of Indexing
Indexing Basics
The Path of the Query
A Comprehensive Indexing Strategy
Specialty Indexes
Summary
Chapter 46: Maximizing Query Plan Reuse
Query Compiling
Query Recompiles
Summary
Chapter 47: Managing Transactions, Locking, and Blocking
The ACID Properties
Programming Transactions
Default Locking and Blocking Behavior
Monitoring Locking and Blocking
Dealing with Deadlocks
Understanding SQL Server Locking
Transaction Isolation Levels
Application Locks
Application Locking Design
Transaction-Log Architecture
Transaction Performance Strategies
Summary
Chapter 48: Data Compression
Understanding Data Compression
Applying Data Compression
Summary
Chapter 49: Partitioning
Partitioning Strategies
Partitioned Views
Partitioned Tables and Indexes
Summary
Chapter 50: Resource Governor
Exploring the Fundamentals of the Resource Governor
Performance Monitoring of Resource Governor
Views and Limitations
Summary
Part IX: Business Intelligence
Chapter 51: Business Intelligence Database Design
Data Warehousing
Designing a Data Warehouse Using a Star Schema
Designing Your Data Warehouse Using a Snowflake Schema
Ensuring Consistency within a Data Warehouse
Loading Data
Summary
Chapter 52: Building, Deploying, and Managing ETL Workflows in Integration Services
Exploring the SSIS Environment in Brief
Exploring the SSIS Environment in More Detail
Deploying and Executing Projects and Packages
Summary
Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX
Analysis Services Quick Start
Analysis Services Architecture
Building a Database
Dimensions
Cubes
Data Storage
Cube Processing
Summary
Chapter 54: Configuring and Administering Analysis Services
Installing Analysis Services
Configuring Basic Analysis Services Settings
Advanced SSAS Deployments
Reviewing Query Performance with SQL Profiler
Summary
Chapter 55: Authoring Reports in Reporting Services
Report Authoring Environments
The Basic Elements of a Report
Building a Report with the Report Wizard
Authoring a Report from Scratch
Exploring the Report Designer
Using Reporting Services Features to Visualize Your Data
Designing the Report Layout
Building Reports with Report Builder
Summary
Chapter 56: Configuring and Administering Reporting Services
Installing Reporting Services
Deploying Reporting Services Reports
Managing Security with Reporting Services
Disaster Recovery
Summary
Chapter 57: Data Mining with Analysis Services
The Data Mining Process
Modeling with Analysis Services
Algorithms
Cube Integration
Summary
Chapter 58: Creating and Deploying BI Semantic Models
What Is a BI Semantic Model?
The Development Environment
Creating BI Semantic Models Using PowerPivot
Extending a BI Semantic Model with PowerPivot
Deploying BI Semantic Models to SharePoint
Managing Automatic Data Refresh of PowerPivot Workbooks in SharePoint 2010
Creating BI Semantic Models Using SQL Server Data Tools
Extending a BI Semantic Model with SQL Server Data Tools
Deploying BI Semantic Models to an Analysis Services Instance
Summary
Chapter 59: Creating and Deploying Power View Reports
Power View Requirements
Creating and Deploying Reports with Power View
Deploying Power View Reports
Summary
End User License Agreement
Guide
Cover
Contents
Begin Reading
List of Tables
Chapter 3: Installing SQL Server
Table 3.1 Minimum Hardware Requirements
Table 3.2 Operating System and Software Patches
Table 3.3 Default Ports for Common SQL Server 2012 Services
Table 3.4 SQL Server Database Compatibility Levels
Table 3.5 SQL Server Database Version Numbers
Table 3.6 Licensing Matrix for Different Processor Core Configurations
Table 3.7 Commonly Used SQL Server 2012 Setup Command Line Parameters
Chapter 4: Client Connectivity
Table 4.1 Three Available Protocols for SQL Server
Table 4.2 SQL Server 2012 Large Values Types
Chapter 5: SQL Server Management and Development Tools
Table 5.1 Useful Query Editor Shortcuts
Chapter 6: Introducing Basic Query Flow
Table 6.1 Standard Comparison Operators
Table 6.2 SQL Wildcards
Chapter 7: Relational Database Design and Creating the Physical Database Schema
Table 7.1 Comparing Database Terms
Table 7.2 Common Relationship Cardinalities
Table 7.3 Violating the First Normal Form
Table 7.4 Conforming to the First Normal Form
Table 7.5 Violating the Second Normal Form
Table 7.6 Conforming to the Second Normal Form
Table 7.7 Violating the Third Normal Form
Table 7.8 Conforming to the Third Normal Form
Chapter 8: Data Types, Expressions, and Scalar Functions
Table 8.1 Character Data Types
Table 8.2 Numeric Data Types
Table 8.3 Date/Time Data Types
Table 8.4 Other Data Types
Table 8.5 Building Expressions
Table 8.6 DateTime Portions Used by Date Functions
Table 8.7 Convert Function Date Styles
Chapter 9: Merging Data with Joins, Subqueries, and CTEs
Table 9.1 Join Types
Chapter 10: Aggregating, Windowing, and Ranking Data
Table 10.1 Basic Aggregate Functions
Table 10.2 New OVER() Clause Arguments
Chapter 12: Modifying Data In SQL Server
Table 12.1 Insert Forms
Chapter 15: Executing Distributed Queries
Table 15.1 Common External Data Sources
Chapter 16: Programming with T-SQL
Table 16.1 System Functions
Table 16.2 Available Severity Codes
Table 16.3 Catch Functions
Chapter 16: Programming with T-SQL
Table 16.4 Differences between RAISERROR and THROW
Chapter 19: Configuring SQL Server
Table 19.1 Start/Stop Configuration Properties
Table 19.2 Memory-Configuration Properties
Table 19.3 Processor-Configuration Properties
Table 19.4 Security-Configuration Properties
Table 19.5 Connection-Configuration Properties
Table 19.6 Advanced Server-Configuration Properties
Table 19.7 Index-Configuration Properties
Table 19.8 Cursor-Configuration Properties
Table 19.9 SQL ANSI–Configuration Properties
Table 19.10 ANSI_WARNINGS and ARITHABORT Behavior
Table 19.11 Trigger Configuration Properties
Table 19.12 Database-State-Configuration Properties
Table 19.13 Recovery-Configuration Properties
Chapter 20: Policy Based Management
Table 20.1 Facet Listing
Chapter 21: Backup and Recovery Planning
Table 21.1 SQL Server Recovery Models
Chapter 22: Maintaining the Database
Table 22.1 DBA Daily Checklist
Chapter 23: Transferring Databases
Table 23.1 Database Transfer Methods
Chapter 25: Asynchronous Messaging with Service Broker
Table 25.1 Resources to Monitor Service Broker Activity
Table 25.2 Service Broker Catalog Views
Table 25.3 Service Broker Dynamic Management Views
Chapter 27: Database Mirroring
Table 27.1 Database Mirroring Safety Levels and Failover Options
Table 27.3 Querying the sys.database_mirroring_witnesses Catalog View
Chapter 30: Configuring and Managing SQL Server with PowerShell
Table 30.1 Control Flow Commands
Table 30.2 Object Cmdlets in PowerShell
Chapter 33: Authorizing Securables
Table 33.1 Permission Options by Securable
Table 33.2 Sample User-Defined Role Permission Assignment
Table 33.3 Sample User and Windows Group Role Assignments
Chapter 36: Creating Triggers
Table 36.1 Trigger Type Comparison
Table 36.2 Inserted and Deleted Tables
Table 36.3 Multirow-Enabled FROM Clauses
Chapter 37: Performance Monitor and PAL
Table 37.1 Key Performance Monitor Counters
Chapter 44: Interpreting Query Execution Plans
Table 44.1 Query Execution Plan Operators
Chapter 45: Indexing Strategies
Table 45.1 Query Path Performance
Chapter 47: Managing Transactions, Locking, and Blocking
Table 47.1 Lock Granularity
Table 47.2 Lock Compatibility
Table 47.3 ANSI-92 Isolation Levels
Table 47.4 Isolation Levels and Lock Duration
Table 47.5 Locking Hints
Chapter 50: Resource Governor
Table 50.1 Example Showing Resource Sharing Among Pools
Chapter 52: Building, Deploying, and Managing ETL Workflows in Integration Services
Table 52.1 How to Configure Your Flat File (on the Advanced Tab)
Table 52.2 Data Flow Sources
Table 52.3 Data Flow Destinations
Table 52.4 Data Flow Transformations
Chapter 55: Authoring Reports in Reporting Services
Table 55.1 Report Objects Available in the Toolbox
Table 55.2 The Text Box Properties Window
Table 55.3 Report Sections
Chapter 56: Configuring and Administering Reporting Services
Table 56.1 Reporting Services Project Deployment Properties
Table 56.2 Default System Roles
Table 56.3 Default Item-Level Roles
Chapter 57: Data Mining with Analysis Services
Table 57.1 Example Classification Matrix
Table 57.2 Common Mining Algorithm Usage
Chapter 59: Creating and Deploying Power View Reports
Table 59.1 Power View Browser Support
Pages
C1
iii
iv
v
vii
viii
ix
xi
xiii
xv
xvi
xvii
xxix
xxx
xxxi
xxxii
1
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
109
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
325
326
327
328
329
330
331
332
333
334
335
336
337
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
453
454
455
456
457
458
459
460
461
462
463
464
465
467
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
635
636
637
638
639
640
641
642
643
644
645
647
648
649
650
651
652
653
654
655
656
657
658
659
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
833
834
835
836
837
838
839
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
877
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
909
910
911
912
913
914
915
916
917
919
920
921
922
923
924
925
926
927
928
929
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
967
968
969
970
971
972
973
974
975
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
995
996
997
998
999
1000
1001
1002
1003
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
