Cargando…
Introduction to SQL Server query optimization : understanding query optimization and built-in optimization tools /
"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 statis...
| Clasificación: | Libro Electrónico |
|---|---|
| Otros Autores: | |
| Formato: | Electrónico Video |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified] :
Apress,
[2019]
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
| Sumario: | "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 |
|---|---|
| Notas: | Title from title screen (viewed September 11, 2019). Date of publication from resource description page. |
| Descripción Física: | 1 online resource (1 streaming video file (48 min., 30 sec.)) |