skip to content
Microsoft SQL server 2014 query tuning & optimization Preview this item
ClosePreview this item
Checking...

Microsoft SQL server 2014 query tuning & optimization

Author: Benjamin Nevarez
Publisher: New York : McGraw-Hill Education, [2015] ©2015
Edition/Format:   eBook : Document : EnglishView all editions and formats
Database:WorldCat
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  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Nevarez, Benjamin.
Microsoft SQL server 2014 query tuning & optimization.
New York : Mcgraw-Hill Education, [2015]
(OCoLC)864700500
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Benjamin Nevarez
ISBN: 9780071829434 0071829431
OCLC Number: 904597713
Description: 1 online resource (1 volume) : illustrations
Contents: Chapter 1: An Introduction to Query Tuning and Optimization Chapter 2: Troubleshooting Queries Chapter 3: The Query Optimizer Chapter 4: Query Operators Chapter 5: Indexes Chapter 6: Statistics Chapter 7: Hekatron Chapter 8: Plan Caching Chapter 9: Data Warehouses Chapter 10: Query Processor Limitations & Hints
Other Titles: Query tuning and optimization
Responsibility: Benjamin Nevarez.

Abstract:

Filled with field-tested techniques for optimizing SQL Server 2014 databases, applications, and data warehouses for speed and performance-plus advanced troubleshooting tips for dealing with existing  Read more...

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/904597713> # Microsoft SQL server 2014 query tuning & optimization
    a schema:Book, schema:CreativeWork, schema:MediaObject ;
   library:oclcnum "904597713" ;
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nyu> ;
   rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://images.contentreserve.com/ImageType-100/0018-1/{93446FA6-92BC-4AF6-A8D5-F66B2D02993E}Img100.jpg'" ;
   schema:about <http://experiment.worldcat.org/entity/work/data/2233605040#Topic/database_management> ; # Database management
   schema:about <http://dewey.info/class/005.7585/e23/> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/2233605040#CreativeWork/sql_server> ; # SQL server.
   schema:about <http://experiment.worldcat.org/entity/work/data/2233605040#Topic/client_server_computing> ; # Client/server computing
   schema:about <http://experiment.worldcat.org/entity/work/data/2233605040#Topic/relational_databases> ; # Relational databases
   schema:about <http://experiment.worldcat.org/entity/work/data/2233605040#Topic/querying_computer_science> ; # Querying (Computer science)
   schema:alternateName "Query tuning and optimization" ;
   schema:author <http://experiment.worldcat.org/entity/work/data/2233605040#Person/nevarez_benjamin> ; # Benjamin Nevarez
   schema:bookFormat schema:EBook ;
   schema:datePublished "2015" ;
   schema:description "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. --"@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/2233605040> ;
   schema:genre "Electronic books"@en ;
   schema:inLanguage "en" ;
   schema:isSimilarTo <http://www.worldcat.org/oclc/864700500> ;
   schema:name "Microsoft SQL server 2014 query tuning & optimization"@en ;
   schema:productID "904597713" ;
   schema:url <http://proquest.safaribooksonline.com/?fpi=9780071829427> ;
   schema:url <https://samples.overdrive.com/microsoft-sql-server-93446f?.epub-sample.overdrive.com> ;
   schema:url <http://proquest.tech.safaribooksonline.de/9780071829427> ;
   schema:url "http://images.contentreserve.com/ImageType-100/0018-1/{93446FA6-92BC-4AF6-A8D5-F66B2D02993E}Img100.jpg" ;
   schema:url <https://www.overdrive.com/search?q=93446FA6-92BC-4AF6-A8D5-F66B2D02993E> ;
   schema:url <http://proquest.safaribooksonline.com/9780071829427> ;
   schema:url <http://www.books24x7.com/marc.asp?bookid=77177> ;
   schema:workExample <http://worldcat.org/isbn/9780071829434> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/904597713> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/2233605040#Person/nevarez_benjamin> # Benjamin Nevarez
    a schema:Person ;
   schema:familyName "Nevarez" ;
   schema:givenName "Benjamin" ;
   schema:name "Benjamin Nevarez" ;
    .

<http://experiment.worldcat.org/entity/work/data/2233605040#Topic/client_server_computing> # Client/server computing
    a schema:Intangible ;
   schema:name "Client/server computing"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/2233605040#Topic/database_management> # Database management
    a schema:Intangible ;
   schema:name "Database management"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/2233605040#Topic/querying_computer_science> # Querying (Computer science)
    a schema:Intangible ;
   schema:name "Querying (Computer science)"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/2233605040#Topic/relational_databases> # Relational databases
    a schema:Intangible ;
   schema:name "Relational databases"@en ;
    .

<http://worldcat.org/isbn/9780071829434>
    a schema:ProductModel ;
   schema:isbn "0071829431" ;
   schema:isbn "9780071829434" ;
    .

<http://www.worldcat.org/oclc/864700500>
    a schema:CreativeWork ;
   rdfs:label "Microsoft SQL server 2014 query tuning & optimization." ;
   schema:description "Print version:" ;
   schema:isSimilarTo <http://www.worldcat.org/oclc/904597713> ; # Microsoft SQL server 2014 query tuning & optimization
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.