Return to home page
Searching: Muskingum library catalog
Record 520 of 850
  Previous Record Previous Item Next Item Next Record
  Reviews, Summaries, etc...
EBOOK
Author Nevarez, Benjamin,
Title Microsoft SQL server 2014 query tuning & optimization / Benjamin Nevarez.
Imprint New York : McGraw-Hill Education, [2015]
2015

LOCATION CALL # STATUS MESSAGE
 OHIOLINK SAFARI EBOOKS    ONLINE  
View online
LOCATION CALL # STATUS MESSAGE
 OHIOLINK SAFARI EBOOKS    ONLINE  
View online
Subject SQL server.
Querying (Computer science)
Database management.
Relational databases.
Client/server computing.
Add Title Query tuning and optimization
Description 1 online resource (1 volume) : illustrations
Note Print version record.
Bibliography Note Includes bibliographical references and index.
Summary This book describes the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution plans. Topics include: understanding how the query optimizer works; troubleshooting queries using extended events, SQL trace, dynamic management views (DMVs), the data collector, and other tools; working with query operators for data access, joins, aggregations, parallelism, and updates; speeding up queries and improving application performance; understanding statistics and how to detect and fix cardinality estimation errors; maximizing OLTP query performance using In-Memory OLTP (Hekaton) features, including memory-optimized tables and natively compiled stored procedures; monitoring and promoting plan caching and reuse; improving the performance of data warehouse queries; and handling query processor limitations with hints and other methods. -- Edited summary from book.
ISBN 9780071829434 (electronic bk.)
0071829431 (electronic bk.)
9780071829427
0071829423
OCLC # 904597713
Additional Format Print version: Nevarez, Benjamin. Microsoft SQL server 2014 query tuning & optimization. New York : Mcgraw-Hill Education, [2015] 0071829423 (OCoLC)864700500