Introduction. 1. Being Objective: Re-Examining Objects in SQL Server. 2. Tools of the Trade. 3. Writing Complex Queries. 4. XML Support. 5. Data Design Beyond Normalization. 6. Speeding Performance: SQL Server Core Storage and Index Structure. 7. More Advanced Index Structures. 8. Views. 9. Scripting 301. 10. Advanced Programmability. 11. Transactions and Locks. 12. Triggers. 13. SQL Cursors. 14. Reporting Services. 15. BCP: The Bulk Copy Program. 16. Getting Integrated. 17. Replication. 18. Looking at Things in Full: Full Text Search. 19. Feeling Security. 20. A Grand Performance: Designing a Database that Performs Well. 21. What Comes After: Forensic Performance Tuning. 22. Administration. 23. SMO: SQL Management Objects. 24. Data Warehousing. Appendix A: System Function Listing. Appendix B: Going Meta: Getting Data About Your Data. Appendix C: Review of Basic Concepts.

Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical code examples. Learn how to write complex queries, build different types of data structures, improve application speed and performance, manage advanced scripting and errors, and design advanced databases the latest edition of this valuable programming guide.

Professional SQL Server 2008 Programming shows experienced developers how to master the increasingly complex feature set of the latest release of Microsoft SQL Server.  The book begins with a concise overview of the new features of SQL Server that will be of interest to experienced developers.   From there, the book quickly moves on to the meat of the title, with extensive code examples. The book covers such topics as:        Writing complex queries        Building more complex types of data structures.        Techniques for improving application speed and performance.        Advanced scripting and error handling.        Advanced methods for handling stored procedures.        SQL cursors        XML and XQuery support        Reporting Services, Integration Services, and Analysis Services        Replication        Security and Performance Tuning        Advanced database design The new edition will be substantially revised---about 40% revised, plus 75 more pages---to cover the extensive and pervasive changes that come with the 2008 release.   SQL Server 2008 brings with it:  new data types, new indexing structures, new manageability features, and advanced time zone handling it is expected that later CTPs will reveal additional changes. The book's companion site will provide all of the source code, so readers can quickly implement the soluitons described in the book.