Product Description
Perfectly intelligent programmers often struggle when forced to work with SQL. Why?Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.

This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you'll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you'll be coding more quickly, writing more efficient code, and applying the full power of SQL

. Filled with the insights of one of the world's leading SQL authorities - noted for his knowledge and his ability to teach what he knows.

. Focuses on auxiliary tables(for computing functions and other values by joins), temporal tables(for temporal queries, historical data, and audit information), and virtual tables(for improved performance).

. Presents clear guidance for selecting and correctly applying the right table technique.

Key coverage includes

*
Using SQL Server 2005 as a.NET runtime host: extending the server while enhancing security, reliability, and performance
* Writing procedures, functions, triggers, and types in.NET languages
* Exploiting enhancements to T-SQL for robust error-handling, efficient queries, and improved syntax
* Effectively using the XML data type and XML queries
* Implementing native SQL Server 2005 Web Services
* Writing efficient, robust clients for SQL Server 2005 using ADO.NET, classic ADO, and other APIs
* Taking full advantage of user-defined types(UDTs), query notifications, promotable transactions, and multiple active result sets(MARS)
* Using SQL Management Objects(SMO), SQL Service Broker, and SQL Server Notification Services to build integrated applications

Product Description
Get the practical, pocket-sized guide for IT professionals who need to administer, maintain, and optimize SQL Server 2008. Written by award-winning author William Stanek, this portable reference delivers essential details for using SQL Server 2008 to help protect and manage your company s data whether automating tasks, creating indexes and views, performing backups and recovery, replicating transactions, tuning performance, managing server activity, importing and exporting data, or performing other key tasks. Featuring quick-reference tables, lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot whether you re at your desk or in the field!
Key Book Benefits
Provides fast facts and immediate reference for administering SQL Server 2008 Delivers must-know details for taking advantage of the improved scalability, security features, and management tools in SQL Server 2008 Features concise tables, easy-to-scan lists, and step-by-step instructions for fast answers, wherever you need them