Knockout Narratives Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    The Powell's Playlist | January 5, 2015

    Tim Johnston: IMG The Powell's Playlist: Songs for Not Sleeping by Tim Johnston



    I once told a medical-profession-type lady that I didn't sleep well, that I awoke all through the night and was awake for hours. "What do you do... Continue »

    spacer

On Order

$46.95
New Trade Paper
Currently out of stock.
Add to Wishlist
Qty Store Section
- Local Warehouse Internet- Marketing

More copies of this ISBN

Microsoft Transact-SQL: The Definitive Guide

by

Microsoft Transact-SQL: The Definitive Guide Cover

 

Synopses & Reviews

Publisher Comments:

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)

Synopsis:

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.

Synopsis:

"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.

Product Details

ISBN:
9780763784164
Author:
Garbus, Jeffrey
Publisher:
Jones & Bartlett Publishers
Author:
Chang, Alvin
Author:
Ratchev, Plamen
Subject:
Document Management
Subject:
Desktop Applications/Databases
Subject:
Computer Science
Subject:
Internet marketing
Publication Date:
20100531
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
512
Dimensions:
9.00x7.40x1.20 in. 1.95 lbs.

Related Subjects

Computers and Internet » Computers Reference » Document Management
Computers and Internet » Computers Reference » General
Computers and Internet » Database » SQL
Computers and Internet » Internet » Marketing
Computers and Internet » Personal Computers » Desktop Applications » Databases
Computers and Internet » Personal Computers » General

Microsoft Transact-SQL: The Definitive Guide New Trade Paper
0 stars - 0 reviews
$46.95 Backorder
Product details 512 pages Wordware Publishing - English 9780763784164 Reviews:
"Synopsis" by , 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.
"Synopsis" by , "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.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.