SQL Server 7 developer's guide

SQL Server?? Developer's Guide The Latest Tools and Best Techniques for Fast Results Packed with enterprise-tested strategies and solutions, this unique guide gives you a comprehensive catalog of best practices for SQL Server development.

Drawing on a combined 25 years of database experience, two veteran developers lead you through the entire lifecycle of a database system, from preliminary modeling to operational rollout.

Along the way, they show you how to utilize C and Java as well as the Microsoft Visual Studio languages -- and capitalize on the enhanced functionality of SQL Server.

Whether you need to jumpstart a new e-commerce project or fine-tune an existing data warehousing system, this incisive guide is an invaluable reference.

Your Complete How-to Guide * Model your application using CASE Tools "Lite" or Erwin * Design Web, client/server, or object-oriented systems * Utilize SQL administration tools and utilities, from Dtswiz to Sqlmaint * Design effective interfaces using styles, libraries, scripts, and help systems * Master the nuts-and-bolts of data definition, from table syntax to locking * Build efficient C and Java programs with SQL * Fine-tune performance using tips on partitioning, procedures, and triggers * Get SQL standards, guidelines, and maxims, as well as advice on third-party tools www.idgbooks.com