Angebote zu "Import" (2 Treffer)

Squeeze - Squeeze - Essential Squeeze [UK Import]
€ 1.39 *
zzgl. € 5.98 Versand
Stand: Dec 8, 2018
Zum Angebot
T-SQL Querying
€ 36.99 *
ggf. zzgl. Versand

Updating both Inside Microsoft SQL Server 2008 T-SQL Programming (Microsoft Press, 2009) and Inside Microsoft SQL Server 2008 T-SQL Querying (Microsoft Press, 2009), the book gives database developers and administrators a detailed look at the internal architecture of T-SQL and a comprehensive programming reference. 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. The book covers many unique techniques that were developed, improved, and polished by the authors over many years of experience, providing highly efficient solutions for common challenges. There?s a deep focus on the performance and efficiency of the techniques and solutions that are covered. The book emphasizes correct understanding of the language and its underlying mathematical foundations. Product Description T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL?s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012. Write faster, more efficient T-SQL code: Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation techniques, including new grouping sets Efficiently perform data-analysis calculations Make the most of T-SQL?s optimized bulk import tools Avoid date/time pitfalls that lead to buggy, poorly performing code Create optimized BI statistical queries without additional software Use programmable objects to accelerate queries Unlock major performance improvements with In-Memory OLTP Master useful and elegant approaches to manipulating graphs About This Book For experienced T-SQL practitioners Includes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL Programming Valuable to developers, DBAs, BI professionals, and data scientists Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics Features + Benefits Covers moving from procedural programming to the language of sets and logic Shows how to optimize query tuning with a top-down methodology Assesses algorithmic complexity to predict performance Compares data-aggregation techniques, including new grouping sets Foreword xv Introduction xvii Chapter 1: Logical query processing 1 Logical query-processing phases 3 Logical query-processing phases in brief 4 Sample query based on customers/orders scenario 6 Logical query-processing phase details 8 Step 1: The FROM phase 8 Step 2: The WHERE phase 14 Step 3: The GROUP BY phase 15 Step 4: The HAVING phase 16 Step 5: The SELECT phase 17 Step 6: The ORDER BY phase 20 Step 7: Apply the TOP or OFFSET-FETCH filter 22 Further aspects of logical query processing 26 Table operators 26 Window functions 35 The UNION, EXCEPT, and INTERSECT operators 38 Conclusion 39 Chapter 2: Query tuning 41 Internals 41 Pages and extents 42 Table organization 43 Tools to measure query performance 53 Access methods 57 Table scan/unordered clustered index scan 57 Unordered covering nonclustered index scan 60 Ordered clustered index scan 62 Ordered covering nonclustered index scan 63 The storage engine?s treatment of scans 65 Nonclustered index seek + range scan + lookups 81 Unordered nonclustered index scan + lookups 91 Clustered index seek + range scan 93 Covering nonclustered index seek + range scan 94 Cardinality estimates 97 Legacy estimator vs. 2014 cardinality estimator 98 Implications of underestimations and overestimations 99 Statistics 101 Estimates for multiple predicates 104 Ascending key problem 107 Unknowns 110 Indexing features 115 Descending indexes 115 Included non-key columns 119 Filtered indexes and statistics 120 Columnstore indexes 123 Inline index definition 130 Prioritizing queries for tuning with extended events 131 Index and query information and

Stand: Dec 10, 2018
Zum Angebot

Ähnliche Suchbegriffe