SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble-shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems.
Stored procedures are compiled T-SQL statements that reside on the database. They are the cornerstones of successful data manipulation, and data-handling operations of every complexity make use of them. This book is an in-depth guide to a key area of database development.
SQL Server expert and author Joseph Sack covers all SQL Server 2000 features, so you'll be able to rely on this book when you're in the field and need quick, effective solutions. Included are hundreds of practical recipes that describe and demonstrate the utility of a feature or functionwith the minimum necessary background theory.
This book is more than just a comprehensive reference tool for Access developers. You'll also find efficient SQL solutions for common Access problems and tasks, as well as helpful hints and warnings on what to avoid.
SMS 2003 Recipes: A Problem-Solution Approach provides you with hundreds of quick-reference solutions. It addresses a wide range of problems that all levels of SMS administrators have reported to the authors in the course of their careers. Some are simple, beginning implementation solutions, while others address high-end automation techniques.
In this book, Seth Bates and Tony Smith walk you through the components and capabilities that make up a SharePoint 2010 environment. Their expertise shines as they provide step-by-step instructions for using and managing these elements, as well as recommendations for how to best leverage them.
SharePoint 2007 Development Recipes, Mark Gerow's hands-on guide to solving common SharePoint 2007 programming dilemmas, is filled with ready-to-use code recipes categorized by problem area. This invaluable reference also includes clear, supporting guidelines to help you modify the code samples for the broadest range of applications.