The T

The T-SQL Programming book is generously laced with practical code samples you can easily use in your own work. The authors think beyond the correctness of the samples and take security, performance, and potential blocking into consideration as well. Therefore, the book contains numerous examples in which the query plans are examined and compared with alternative plans. For instance, in Chapter 9, you will find information about how to use dynamic management views (DMVs) to troubleshoot blocking scenarios. DMVs were newly introduced in SQL Server 2005 to provide information about the server state that can be used to monitor the health of a server instance, diagnose problems, and tune performance.-The T-SQL Programming book is generously laced with practical code samples you can easily use in your own work. The authors think beyond the correctness of the samples and take security, performance, and potential blocking into consideration as well. Therefore, the book contains numerous examp