An in–depth look at SQL Server and best practices for troubleshooting When faced with a variety of SQL Server issues, you need to be able to troubleshoot SQL Server as well as its underlying operating system. To that end, this author group of SQL Server experts presents you with invaluable advice that brings together—and simplifies—practical internal information concerning SQL Server along with troubleshooting techniques and methodologies. Packed with real–world examples of ways to effectively use troubleshooting tools, this book shows you how to efficiently and accurately determine the root of your SQL Server problem so you can successfully resolve it. Escorts you through the lifecycle of a query to establish an understanding of the fundamental concepts and architectures Examines the use of memory including the physical components, Windows memory management, and SQL Server?s own memory architecture Reviews SQL Server wait types and how to...