rdf-syntax-grammar
mods:
  schema location: http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-2.xsd
  title info:
    title: Introduction to SQL Server Query Optimization
    sub title: Understanding Query Optimization and Built-in Optimization Tools
  name:
    name part: Pollack, Ed
    role:
      role term: creator
    role:
      role term: author.
  name:
    name part: Safari, an O'Reilly Media Company
  type of resource: moving image
  genre: videorecording
  genre: Electronic videos.
  origin info:
    place:
      place term: xx
    date issued: 2019
    edition: 1st edition.
    issuance: monographic
  language:
    language term: eng
  physical description:
    form: remote
    extent: 1 online resource (1 video file, approximately 48 min.)
  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. What You'll Learn Discover how SQL Server optimizes a query and generates an execution plan Enable, read, and decipher execution plans for query analysis Identify a variety of common execution plan operators Use STATISTICS IO to gauge query impact on memory and disk resources Measure query duration using STATISTICS TIME Analyze problem queries to find the source of performance problems Identify common query mistakes and how to quickly resolve them Who This Video Is For Database administrators, developers, or anyone who writes TSQL queries on a regular basis. For all database professionals who need to write efficient code that executes quickly while consuming minimal resources.
  note: Pollack, Ed.
  note: Videorecording.
  note: Electronic reproduction. Boston, MA : Safari, Available via World Wide Web. 2019.
  note: Mode of access: World Wide Web.
  identifier: 9781484251447
  identifier: https://proxy.library.tamu.edu/login
  record info:
    record creation date: 190719
    record change date: 20260128223404.9
    record identifier: in00004251076