Product Description: Sams Teach Yourself Transact-SQL in 21 Days, 2E will teach programmers how to develop Transact-SQL queries. There will be a focus on providing methods for improving productivity without a reducing performance. Specifically, the reader will:Learn Transact-SQL syntax Learn how to add, delete, and modifying data using Transact-SQL Understand coding standards Review variations from ANSI-standard SQL Be presented with basic server operations...read more (view table of contents, read Amazon.com's description)

Gives readers specific solutions that will improve productivity and maximize performance from the SQL Server database, outlining the techniques to write flexible and effective applications. Original. (Intermediate) (view table of contents)

Product Description: The new release of SQL Server 11 is packed with power, breaking many previous SYBASE SQL Server benchmarks-achieving over a 100% improvement over both SQL Server 4.9 and 10. With all this new power at your command, you need a comprehensive book to detail the best ways to program, tune, and administer your databases...read more

Product Description: Configure, tune, and exploit the full power of the MS SQL Server. Create a database to fit your needs Write efficient SQL queries Master transaction management Design indexes for query optimization Learn remote server management Secure your server and your network Replicate your database and manage it on various platforms Back up and restore your server Implement continuous database logs Learn ODBC programming Companion CD-ROM includes demos from leading vendors of SQL Servers accessory products...read more