skip to content
Introduction to SQL Server query optimization : understanding query optimization and built-in optimization tools Preview this item
ClosePreview this item
Checking...

Introduction to SQL Server query optimization : understanding query optimization and built-in optimization tools

Author: Edward Pollack, (Database administrator)
Publisher: [Place of publication not identified] : Apress, [2019]
Edition/Format:   eVideo : Clipart/images/graphics : EnglishView all editions and formats
Summary:
"Begin your journey into query optimization by learning the basics of how SQL Server processes a query from start to finish. Once this foundation is established, you will focus on execution plans: What are they? How do we read them? And what are their more common operations? A variety of statistics options will be introduced that provide insight into query duration and the load that a given query presents on memory  Read more...
Rating:

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

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

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

Details

Material Type: Clipart/images/graphics, Internet resource, Videorecording
Document Type: Internet Resource, Computer File, Visual material
All Authors / Contributors: Edward Pollack, (Database administrator)
OCLC Number: 1119557724
Notes: Title from title screen (viewed September 11, 2019).
Date of publication from resource description page.
Performer(s): Presenter, Edward Pollack.
Description: 1 online resource (1 streaming video file (48 min., 30 sec.)) : digital, sound, color
Responsibility: Edward Pollack.

Abstract:

"Begin your journey into query optimization by learning the basics of how SQL Server processes a query from start to finish. Once this foundation is established, you will focus on execution plans: What are they? How do we read them? And what are their more common operations? A variety of statistics options will be introduced that provide insight into query duration and the load that a given query presents on memory and storage resources. With a set of tools defined, you will tackle a variety of common optimization challenges. You’ll review some common problems in which performance is inadequate and then solutions to mitigate those problems and improve performance. These basic patterns will provide a format for viewing and analyzing queries with the goal of being able to identify the source of the problem when a query is running too slow."--Resource description page.

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/1119557724> # Introduction to SQL Server query optimization : understanding query optimization and built-in optimization tools
    a schema:Movie, schema:VideoObject, schema:CreativeWork ;
    library:oclcnum "1119557724" ;
    rdfs:comment "Unknown 'gen' value: cig" ;
    schema:about <http://experiment.worldcat.org/entity/work/data/9516722390#Topic/client_server_computing> ; # Client/server computing
    schema:about <http://experiment.worldcat.org/entity/work/data/9516722390#Topic/querying_computer_science> ; # Querying (Computer science)
    schema:about <http://experiment.worldcat.org/entity/work/data/9516722390#Topic/relational_databases> ; # Relational databases
    schema:about <http://experiment.worldcat.org/entity/work/data/9516722390#CreativeWork/sql_server> ; # SQL server.
    schema:about <http://experiment.worldcat.org/entity/work/data/9516722390#Topic/database_management> ; # Database management
    schema:creator <http://experiment.worldcat.org/entity/work/data/9516722390#Person/pollack_edward_database_administrator> ; # (Database administrator) Edward Pollack
    schema:datePublished "2019" ;
    schema:description ""Begin your journey into query optimization by learning the basics of how SQL Server processes a query from start to finish. Once this foundation is established, you will focus on execution plans: What are they? How do we read them? And what are their more common operations? A variety of statistics options will be introduced that provide insight into query duration and the load that a given query presents on memory and storage resources. With a set of tools defined, you will tackle a variety of common optimization challenges. You’ll review some common problems in which performance is inadequate and then solutions to mitigate those problems and improve performance. These basic patterns will provide a format for viewing and analyzing queries with the goal of being able to identify the source of the problem when a query is running too slow."--Resource description page."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/9516722390> ;
    schema:inLanguage "en" ;
    schema:name "Introduction to SQL Server query optimization : understanding query optimization and built-in optimization tools"@en ;
    schema:productID "1119557724" ;
    schema:url <http://proquest.safaribooksonline.com/?fpi=9781484251447> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/1119557724> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/9516722390#Person/pollack_edward_database_administrator> # (Database administrator) Edward Pollack
    a schema:Person ;
    schema:familyName "Pollack" ;
    schema:givenName "Edward" ;
    schema:name "(Database administrator) Edward Pollack" ;
    .

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

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

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

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

<http://www.worldcat.org/title/-/oclc/1119557724>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
    schema:about <http://www.worldcat.org/oclc/1119557724> ; # Introduction to SQL Server query optimization : understanding query optimization and built-in optimization tools
    schema:dateModified "2019-10-11" ;
    void:inDataset <http://purl.oclc.org/dataset/WorldCat> ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

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