Query Plans

SQL Server: Introduction to Query Store  eBooks & eLearning

Posted by naag at Feb. 9, 2017
SQL Server: Introduction to Query Store

SQL Server: Introduction to Query Store
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3 Hours | 682 MB
Genre: eLearning | Language: English

One of the most highly anticipated new features in SQL Server 2016 is Query Store. It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely query plans and run-time statistics.

Pluralsight - SQL Server Query Plan Analysis  eBooks & eLearning

Posted by naag at Feb. 10, 2016
Pluralsight - SQL Server Query Plan Analysis

Pluralsight - SQL Server Query Plan Analysis
MP4 | Video: AVC 1024x768 | Audio: AAC 44KHz 2ch | Duration: 2 Hours 14Min | 507 MB
Genre: eLearning | Language: English

Learn how to interpret and analyze SQL Server query plans, making performance problems easier to recognize and understand, applicable to developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onwards

Pluralsight - SQL Server: Troubleshooting Query Plan Quality Issues [repost]  eBooks & eLearning

Posted by house23 at May 11, 2015
Pluralsight - SQL Server: Troubleshooting Query Plan Quality Issues [repost]

Pluralsight - SQL Server: Troubleshooting Query Plan Quality Issues
WMW | WMV3 538kbps | English | 1024x768 | 15fps | 2h 20mins | WMA2 stereo 128kbps | 396 MB
Genre: Video Training

There are many problems that can lower the performance of your workload and one of the most common is an incorrect query plan. Often the poor query plan is chosen because the cardinality estimate is wrong - the estimate by the query processor of how many table rows will be involved in the query. This course shows you how to recognize when the query processor has an incorrect estimate, along with explaining and showing a multitude of possible causes, plus how to fix them. The course starts with explaining why query plan quality is important, and then shows how to easily spot cardinality estimate issues from examining query plans. The majority of the course shows all the possible causes of cardinality estimates being incorrect along with how to fix them, and more than 25 demos to walk you through practical examples of the concepts and problems in the lectures.

Fundamentals of Physical Design and Query Compilation (repost)  eBooks & eLearning

Posted by interes at Jan. 25, 2015
Fundamentals of Physical Design and Query Compilation (repost)

Fundamentals of Physical Design and Query Compilation (Synthesis Lectures on Data Management) by David Toman and Grant Weddell
English | 2011-08-01 | ISBN: 1608452786 | PDF | 124 pages | 1,7 MB

Fundamentals of Physical Design and Query Compilation  eBooks & eLearning

Posted by ChrisRedfield at Feb. 24, 2013
Fundamentals of Physical Design and Query Compilation

David Toman, Grant Weddell - Fundamentals of Physical Design and Query Compilation
Published: 2011-08-01 | ISBN: 1608452786 | PDF | 124 pages | 3 MB

SQL Server: Troubleshooting Query Plan Quality Issues (2013)  eBooks & eLearning

Posted by ParRus at Feb. 13, 2013
SQL Server: Troubleshooting Query Plan Quality Issues (2013)

SQL Server: Troubleshooting Query Plan Quality Issues
English | WMV | 1024 x 768 | WMV3 ~223 kbps | 15 fps
WMA | 128 Kbps | 44.1 KHz | 2 channels | 2h 20mn | 396 MB
Genre: Video Tutorial / Programming (2013)

Learn how to identify, diagnose, and prevent problems where SQL Server chooses the incorrect query plan for your critical queries, applicable to developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onwards. There are many problems that can lower the performance of your workload and one of the most common is an incorrect query plan. Often the poor query plan is chosen because the cardinality estimate is wrong - the estimate by the query processor of how many table rows will be involved in the query.

EMS SQL Query 2007 for PostgreSQL 3.1.0.1  Software

Posted by egent006 at April 10, 2008
EMS SQL Query 2007 for PostgreSQL 3.1.0.1

EMS SQL Query 2007 for PostgreSQL 3.1.0.1 7.0 MB

EMS SQL Query for PostgreSQL is a utility that lets you quickly and simply build SQL queries to PostgreSQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query, set the selection criteria and much more. You can work with several queries at once, edit queries and view the execution results in several modes and perform any other operations you may need in your work with database queries

EMS SQL Query 2007 for DB2 3.1.0.1  Software

Posted by egent006 at April 3, 2008
EMS SQL Query 2007 for DB2 3.1.0.1

EMS SQL Query 2007 for DB2 3.1.0.1 | 6.5 MB

EMS SQL Query for DB2 is a utility that lets you quickly and simply build SQL queries to IBM DB2 databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query, set the selection criteria and much more.

Practical Maintenance Plans in SQL Server: Automation for the DBA  eBooks & eLearning

Posted by roxul at April 22, 2016
Practical Maintenance Plans in SQL Server: Automation for the DBA

Bradley Beard, "Practical Maintenance Plans in SQL Server: Automation for the DBA"
English | ISBN: 1484218949 | 2016 | 296 pages | PDF, EPUB | 22 + 8 MB
SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server) (Repost)

SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server) by Sajal Dam, Grant Fritchey
Publisher: Apress | 2009 | ISBN: 1430219025 | 600 pages | PDF | 12,2 MB

SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems.