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)
Based on the best-selling Teach Yourself series, this comprehensive book provides readers with the techniques they need to not only write flexible and effective applications that produce efficient results but also decrease the performance demands on the server. In no time, users will master methods that will improve productivity and maximize performance. - Explores topics such as coding standards, the CASE function, bitmaps, and more
- Q&A sections, exercises, and week-at-a glance previews make learning a breeze
- A support site for the book will be set up on the Sams Web site-providing access to a SQL Server, HTML interface that accepts full SQL queries, hands-on learning of Transact-SQL for those that do not have access to a SQL Server, and more