| 000 | 02311nam a2200277 a 4500 | ||
|---|---|---|---|
| 001 | vtls000044031 | ||
| 003 | KUKTEM | ||
| 005 | 20251117145610.0 | ||
| 008 | 090914t2009 waua f 001 0 eng d | ||
| 020 | _a0735626030 | ||
| 020 | _a9780735626034 | ||
| 039 | 9 |
_a201107132251 _bVLOAD _c201009071446 _djamie _y200909141034 _zshikin |
|
| 040 | _aUMP | ||
| 090 | _aQA76.73.S67 I67 2009 | ||
| 245 | 0 | 0 |
_aInside Microsoft SQL Server 2008 : _bT-SQL querying / _cItzik Ben-Gan ... [et al.] |
| 260 |
_aRedmond, Wash. : _bMicrosoft Press, _cc2009 |
||
| 300 |
_axxiv, 798 p. : _bill. ; _c23 cm. |
||
| 500 | _aIncludes index | ||
| 505 | 0 | _aChapter 1: Logical Query Processing -- Chapter 2: Set Theory and Predicate Logic -- Chapter 3: The Relational Model -- Chapter 4: Query Tuning -- Chapter 5: Algorithms and Complexity -- Chapter 6: Subqueries, Table Expressions and Ranking Functions -- Chapter 7: Joins and Set Operations -- Chapter 8: Aggregating and Pivoting Data -- Chapter 9: TOP and APPLY -- Chapter 10: Data Modification -- Chapter 11: Querying Partitioned Tables -- Chapter 12: Graphs, Trees, Hierarchies and Recursive Queries -- Appendix A: Logic Puzzles | |
| 520 | _aMaster the mechanics behind advanced querying and tuning - for faster, more scalable code. Tackle the toughest set-based querying and query tuning problems - guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals - and gain practical approaches and advanced techniques to optimize your code’s performance. Discover how to: move from procedural programming to the language of sets and logic, optimize query tuning with a top-down methodology, assess algorithmic complexity to predict performance, compare data-aggregation techniques, including new grouping sets, manage data modification - insert, delete, update, merge - for performance, write more efficient queries against partitioned tables, work with graphs, trees, hierarchies, and recursive queries, and use pure-logic puzzles to sharpen your problem-solving skills | ||
| 630 | 0 | 0 | _aSQL server |
| 650 | 0 | _aClient/server computing | |
| 650 | 0 | _aRelational databases | |
| 700 | 1 | _aBen-gan, Itzik. | |
| 999 |
_aVIRTUA40 _c49582 _d49588 |
||
| 999 | _aVTLSSORT0080*0200*0201*0400*0900*2450*2600*3000*5000*5050*5200*6300*6500*6501*7000*9991 | ||