tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P6

Microsoft SQL Server 2008 R2 Unleashed- P6:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 4 Microsoft SQL Server 2008 R2 Unleashed SQL Server high availability provide some expert advice in these areas. Task scheduling and notification using SQL Server Agent and using the new Policy Based Management feature are also discussed in this part. Part IV SQL Server Database Administration This part delves into the administrative tasks associated with creating and managing a SQL Server 2008 database including the creation and management of database objects such as tables indexes views stored procedures functions and triggers. It also provides coverage of the Database Snapshots and an overview of database maintenance tasks and responsibilities. Part V SQL Server Performance and Optimization This part provides information to help you get the best performance out of SQL Server. It begins with a discussion of data structures indexes and performance key items to understand to help ensure good database performance. It then builds on that information with chapters on query optimization and analysis locking database design and performance and ways to manage workloads using the new Resource Governor then it finishes with a methodology for monitoring and optimizing SQL Server performance. Part VI SQL Server Application Development This part includes a comprehensive overview of what s new in T-SQL in SQL Server 2008 and SQL Server 2008 R T-SQL programming guidelines tips and tricks and advanced stored procedure programming and optimization. In addition chapters in this Part provide an overview of .NET integration with SQL Server and creating .NET CLR objects information working with XML in SQL Server and working with additional SQL Server components that are not part of the core database engine such as Web Services Service Broker and Full-Text Search. Part VII SQL Server Business Intelligence Features This Part includes a comprehensive overview of SQL Server 2008 R2 s built-in business intelligence features Analysis Services Integration Services and Reporting Services .