- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
New Trade Paper
Currently out of stock.
More copies of this ISBN
Microsoft Transact-SQL: The Definitive Guideby Jeffrey Garbus
Synopses & Reviews
SQL Server 2008 is a database management system (DBMS) which has enormous and increasing market penetration worldwide for corporations from one-person startups to Fortune 100 corporations. It is used to contain and manage data. Transact-SQL is the proprietary language extension with which database code is written. According to industry studies, 70-80% of database performance problems are caused by poorly written transact-SQL code. Microsoft Transact-SQL: The Definitive Guide is a comprehensive guide to the T-SQL language written for the MS SQL Server 2008 developer having performance problems with SQL. The text includes case studies and examples demonstrating how to write or rewrite T-SQL source code. Some Topics covered include several ways of writing code for optimal performance and maintainability such as stored procedures versus dynamic SQL as well as subqueries versus joins; advanced SQL programming techniques including characteristic functions, common table expressions, refactoring, cubes, and dynamic queries; methods for identifying and fixing poorly written code including Profiler, DMVs, third-party tools, and reading query plans.
Book News Annotation:
This guide is not intended to be a complete Microsoft Transact-SQL reference manual; instead, it teaches how to write good code and rewrite bad code, and how to understand microscale and macroscale performance issues. Part I, on basic programming topics, covers topics such as SQL basics, tables, views, triggers, and common table expressions. Part II focuses on performance, with material on graphical query plans, indexes, and subquery optimization. Part III covers advanced SQL techniques, such as set-oriented programming versus procedural code, grouping data, and refactoring. Exercises, solutions, and three case studies are included. Garbus is a computer consultant. Annotation ©2010 Book News, Inc., Portland, OR (booknews.com)
According To Industry Studies, 70-80% Of Database Performance Problems Are Caused By Poorly Written Transact-SQL Code. Microsoft Transact-SQL: The Definitive Guide Is A Comprehensive Guide To The T-SQL Language Written For The MS SQL Server 2008 Developer Having Performance Problems With SQL. The Text Includes Case Studies And Examples Demonstrating How To Write Or Rewrite T-SQL Source Code. Some Topics Covered Include Several Ways Of Writing Code For Optimal Performance And Maintainability Such As Stored Procedures Versus Dynamic SQL As Well As Subqueries Versus Joins; Advanced SQL Programming Techniques Including Characteristic Functions, Common Table Expressions, Refactoring, Cubes, And Dynamic Queries; Methods For Identifying And Fixing Poorly Written Code Including Profiler, Dmvs, Third-Party Tools, And Reading Query Plans.
"Microsoft Transact-SQL" is a comprehensive guide to the T-SQL language written for the MS SQL Server 2008 developer having performance problems with SQL. The text includes case studies and examples demonstrating how to write or rewrite T-SQL source code.
What Our Readers Are Saying
Computers and Internet » Computers Reference » Document Management