Databases-XdownX

Troubleshooting Oracle Performance By Christian Antognini
Posted: March 13th, 2009, 2:10pm CET

Tags:    [edit]

Troubleshooting Oracle Performance
By Christian Antognini


PART 1 Foundations

CONTENTS
CHAPTER 1 Performance Problems.. . . . . . . . 3
CHAPTER 2 Key Concepts ..13
PART 2 Identification
CHAPTER 3 Identifying Performance Problems. . . . . . . . . . . . . 35
PART 3 Query Optimizer
CHAPTER 4 System and Object Statistics.. 109
CHAPTER 5 Configuring the Query Optimizer. . . . . . . . . . . . . . 169
CHAPTER 6 Execution Plans.. . . . . . . . . . . . . 195
CHAPTER 7 SQL Tuning Techniques.. . . . . . 247
PART 4 Optimization
CHAPTER 8 Parsing... . . . . 309
CHAPTER 9 Optimizing Data Access.. . . . . . 339
CHAPTER 10 Optimizing Joins.. . . . . . . . . . . . 409
CHAPTER 11 Beyond Data Access and Join Optimization. . . . 459
CHAPTER 12 Optimizing the Physical Design. . . . . . . . . . . . . . . 527
PART 5 Appendixes
APPENDIX A Downloadable Files.. . . . . . . . . . 551
APPENDIX B Bibliography..563
INDEX.... . . . . 567

CODEhttp://2341887079644.usercash.com

Tags:    [edit]

SQL Server 2008 Transact-SQL Recipes

by Joseph Sack


Contents:
CHAPTER 1 SELECT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
CHAPTER 2 Perform, Capture, and Track Data Modifications . . . . . . . . . . . . 63
CHAPTER 3 Transactions, Locking, Blocking, and Deadlocking . . . . . . . . . 115
CHAPTER 4 Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143
CHAPTER 5 Indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197
CHAPTER 6 Full-Text Search . . . . . . . . . . . . . . . . . . . . . . . 217
CHAPTER 7 Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 239
CHAPTER 8 SQL Server Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . 257
CHAPTER 9 Conditional Processing, Control-of-Flow, and Cursors . . . . . . . . . . . . . . . 307
CHAPTER 10 Stored Procedures . . . . . . . . . . . . . . . . . . . . . 325
CHAPTER 11 User-Defined Functions and Types . . . . . . . . . . . . . . . 343
CHAPTER 12 Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 373
CHAPTER 13 CLR Integration . . . . . . . . . . . . . . . . . . . . . . . . 401
CHAPTER 14 XML, Hierarchies, and Spatial Data. . . . . . . . . . . . . . . 419
CHAPTER 15 Hints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 449
CHAPTER 16 Error Handling . . . . . . . . . . . . . . . . . . . . . . . . . 459
CHAPTER 17 Principals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 475
CHAPTER 18 Securables, Permissions, and Auditing . . . . . . . . . . . . . . . . . . . . 501
CHAPTER 19 Encryption. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 547
CHAPTER 20 Service Broker. . . . . . . . . . . . . . . . . . . . . . . . . 579
CHAPTER 21 Configuring and Viewing SQL Server Options . . . . . . . . . . 615
CHAPTER 22 Creating and Configuring Databases . . . . . . . . . . . . . . . . . . 621
CHAPTER 23 Database Integrity and Optimization. . . . . . . . . . . . . . . . . . . 669
CHAPTER 24 Maintaining Database Objects and Object Dependencies . . . . . . . . . . . . 687
CHAPTER 25 Database Mirroring . . . . . . . . . . . . . . . . . . . . . 697
CHAPTER 26 Database Snapshots . . . . . . . . . . . . . . . . . . . . 717
CHAPTER 27 Linked Servers and Distributed Queries . . . . . . . . . . . . . . . 723
CHAPTER 28 Query Performance Tuning . . . . . . . . . . . . . . . . . . . . . . . . . . . 739
CHAPTER 29 Backup and Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 789
INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 823

CODEhttp://3365674861241.usercash.com

Tags:    [edit]

Beginning SQL Server 2008 -for Developers From Novice to Professional
by Robin Dewson

Contents:
■CHAPTER 1 SQL Server 2008 Overview and Installation . . . . . . . . . . . . . . . .. . . 1
■CHAPTER 2 SQL Server Management Studio . . . . . . . . . . . . . . . . . . . . . .. . . . 25
■CHAPTER 3 Database Design and Creation . . . . . . . . . . . . . . . . . . . . . . . . . . 51
■CHAPTER 4 Security and Compliance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91
■CHAPTER 5 Defining Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119
■CHAPTER 6 Creating Indexes and Database Diagramming . . . . . . . . . . . . . . . . 151
■CHAPTER 7 Database Backups, Recovery, and Maintenance . . . . . . . . . . . . . . 181
■CHAPTER 8 Working with the Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 249
■CHAPTER 9 Building a View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 307
■CHAPTER 10 Stored Procedures and Functions . . . . . . . . . . . . . . . . . . . . . . . 329
■CHAPTER 11 T-SQL Essentials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 355
■CHAPTER 12 Advanced T-SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 395
■CHAPTER 13 Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 417
■CHAPTER 14 SQL Server 2008 Reporting Services . . . . . . . . . . . . . . . .. . . . . . 439

CODEhttp://5581274952273.usercash.com

Tags:    [edit]