T-SQL Querying: Inside Microsoft® SQL Server" 2005
% SALE
T-SQL Querying: Inside Microsoft® SQL Server" 2005
% SALE
% SALE
Description
Take a detailed look at the internal architecture of T-SQL--and unveil the power of set-based querying--with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language--solving complex problems with real-world solutions. Discover how to: Understand logical and physical query processingApply a methodology to optimize query tuningSolve relational division problemsUse CTEs and ranking functions to simplify and optimize solutionsAggregate data with various techniques, including tiebreakers, pivoting, histograms, and grouping factorsUse the TOP option in a query to modify dataQuery specialized data structures with recursive logic, materialized path, or nested sets solutionsPLUS--Improve your logic and get to the heart of querying problems with logic puzzles Get code and database samples on the Web
Product details
- Type:
- Book
- Binding:
- Paperback
- Edition:
- 1
- Languages:
-
Published:
English
,
Original:
English
- Number of Pages:
-
632
- Publisher:
-
Microsoft Press
- Publication Date:
-
2006-03-29
- Release Date:
-
2006-04-26
- ISBN / EAN:
-
9780735623132
- Weight:
-
1270 g
- Dimensions:
-
23/18/4 cm
- GPSR Manufacturer Reference:
-
[email protected]
Die gelieferte Auflage kann ggf. abweichen.
Currently sold out
Back in stock email
Add to Wishlist