Related tags: Server [+], Microsoft [+], 2007 [+], Exchange [+], with [+], Visio [+], Sense [+], Security [+], SQL [+], Relational [+], Perimeter [+], Office [+], Network [+], Mcr00ft [+], Making [+], Information [+], Examples [+], Databases [+], 2005 [+], Windows, Out, M
Dive deep into the internals of query tuning and optimization in SQL Server 2005 with this comprehensive reference. Understanding the internals of SQL Server helps database developers and administrators to better create, access, and effectively process information from enterprise data. Written by experts on SQL Server, this volume from the Inside Microsoft SQL Server series of books focuses on query tuning and optimization. Youll take an in-depth look at the best ways to make queries more efficient and effective, while maximizing existing resources. Includes extensive code samples and table examples to help database developers and administrators understand the intricacies and help promote mastery of query tuning and optimization. (more…)
Aimed at equipping students with the necessary skills to build practical databases in the real world as well as ensuring that they have a sufficient theoretical grounding in the subject.
Database books currently tend to fall into two categories: highly theoretical and detailed textbooks and manuals which teach how to use the software but not the underlying theory. Neither type of book explains why the reader would want to do many of the things they describe. Marklyn and Whitehorn cover essential relational database theory and explain how to build databases securely - without bogging them down into too much detail and endless formulae. They start by explaining interface components and letting you build working databases. Along the way the authors guide you through potential disasters and provide the techniques to avoid them. Inside Relational Databases is aimed at equipping students with the necessary skills to build practical databases in the 'real world' as well as ensuring that they have a sufficient theoretical grounding in the subject. --This text refers to an out of print or unavailable edition of this title. Read more...
Publisher: Microsoft Press
