Description |
1 online resource |
|
text file |
Bibliography |
Includes bibliographical references and index. |
Contents |
1. Logical query processing -- 2. Physical query processing -- 3. Query tuning -- 4. Subqueries, table expressions, and ranking functions -- 5. Joins and set operations -- 6. Aggregating and pivoting data -- 7. TOP and APPLY -- 8. Data modification -- 9. Graphs, trees, hierarchies, and recursive queries -- A. Logic puzzles. |
Summary |
This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL) - one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on advanced querying techniques and how queries are interpreted and processed by the SQL Server execution engine. You'll get in-depth coverage of the sophisticated uses of T-SQL, including the differences between logical and physical processing, nesting of queries, and much more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL. |
Subject |
SQL server -- Handbooks, manuals, etc.
|
|
SQL server / Handbooks, manuals, etc. |
|
SQL server |
|
SQL (Computer program language) -- Handbooks, manuals, etc.
|
|
Client/server computing.
|
|
SQL (Langage de programmation) -- Guides, manuels, etc. |
|
Architecture client-serveur (Informatique) |
|
SQL (Computer program language) -- Handbooks, manuals, etc. |
|
Client-server computing. |
|
Client/server computing |
|
SQL (Computer program language) |
|
SQL Server 2005 |
|
Microsoft SQL Server. |
|
Databanken. |
|
Programmeertalen. |
Genre |
Electronic book.
|
|
Handbooks and manuals
|
Added Author |
Kollar, Lubor.
|
|
Sarka, Dejan.
|
Added Title |
T-SQL querying |
|
Transact-SQL querying |
Other Form: |
Print version: Ben-Gan, Itzik. Inside Microsoft SQL server 2005. Redmond, Wash. : Microsoft Press, ©2006 0735623139 (DLC) 2006921724 (OCoLC)68810472 |
ISBN |
0735623139 |
|
9780735623132 |
|
9780735635258 (electronic bk.) |
|
0735635250 (electronic bk.) |
Standard No. |
0735623139 |
|