Microsoft SQL Server 2008 All–in–One Desk Reference For Dummies

Robert D. Schneider is a database optimization consultant who has been delivering software solutions for 15 years. Darril Gibson is a professional trainer specializing in certification and Microsoft technologies.

I ntroduction 1 Book I: Essential Concepts 7 Chapter 1: Introducing SQL Server 2008 9 Chapter 2: SQL Server Architecture and Key Concepts 15 Chapter 3: Getting Started, Getting Around 23 Chapter 4: Setting Up SQL Server 2008 35 Chapter 5: Using SQL Server Management Studio 59 Book II: Designing and Using Databases 73 Chapter 1: Setting Up a Database 75 Chapter 2: Care and Feeding of Your Database 89 Chapter 3: Data Types and How to Use Them 99 Chapter 4: Constructing New Tables 121 Chapter 5: Looking After Your Tables 141 Chapter 6: Understanding Relationships 155 Book III: Interacting with Your Data 175 Chapter 1: Using Proper Normalization Techniques 177 Chapter 2: The SQL Server Optimizer 187 Chapter 3: Using the Query Designer 201 Chapter 4: Setting Query Options 213 Chapter 5: Searching for Information 231 Chapter 6: Organizing Query Results 257 Chapter 7: Modifying Your Data 265 Chapter 8: Taking Advantage of Views 273 Chapter 9: Advanced Query Topics 291 Book IV: Database Programming 313 Chapter 1: Understanding Transact-SQL 315 Chapter 2: Stored Procedures and Functions 331 Chapter 3: Triggers 349 Chapter 4: Working with Visual Studio 361 Chapter 5: Web Services 375 Chapter 6: Developing Remote Applications 385 Chapter 7: Advanced Development Topics 401 Book V: Reporting Services 419 Chapter 1: Introduction to SQL Server Reporting Services 421 Chapter 2: Creating Reports with Report Builder 435 Chapter 3: Creating Reports with Report Designer 449 Chapter 4: Integrating Reports 469 Book VI: Analysis Services 477 Chapter 1: Introduction to SQL Server Analysis Services 479 Chapter 2: Creating Business Intelligence Solutions with BIDS 493 Chapter 3: Data Mining and Maintaining Analysis Services Objects 517 Book VII: Performance Tips and Tricks 529 Chapter 1: Working with the SQL Server Optimizer 531 Chapter 2: Using Performance Monitoring Tools 541 Chapter 3: Data Access Strategies 569 Chapter 4: Tuning SQL Server 587 Book VIII: Database Administration 601 Chapter 1: Configuring SQL Server 603 Chapter 2: Performing Major Administrative Tasks 619 Chapter 3: Security: Keeping SQL Server Safe 647 Chapter 4: Integration and Your Database 661 Chapter 5: Replication 677 Chapter 6: Spreading the Load with Partitioning 693 Book IX: Appendixes 701 Appendix A: Ten Sources of Information on SQL Server 2008 703 Appendix B: Troubleshooting SQL Server 2008 707 Appendix C: Glossary 715 Index 725