SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more.
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.
This book contrasts the application-centric development approach to the architecture-centric development approach, introducing the concept of the metamorphic superpatternthe capability of a software program to dynamically adapt to changing application requirements without rebuilding the binary executable.
This book tackles common problems and scenarios that on-the-job developers face every day by revealing code and detailed solutions. You'll quickly be able to integrate real-world, functioning code into your applicationsand save hours of coding time.
Business intelligence (BI) software allows you to view different components of a business using a single visual platform, which makes comprehending mountains of data easier. This book shows BI concepts put into action using Silverlight 4.