Query Plans

Pluralsight - SQL Server Query Plan Analysis  

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]

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.

Mastering the Basics of SQL Server Query Optimization  eBooks & eLearning

Posted by C2U at Feb. 4, 2016
Mastering the Basics of SQL Server Query Optimization

Mastering the Basics of SQL Server Query Optimization
1.5 Hours | Video: h264, yuv420p, 1280x720 | Audio: aac, 44100 Hz, 2 ch | 294 MB
Genre: eLearning | Language: English

Learn to Create Optimal Execution Plans for Your Queries

Inside the SQL Server Query Optimizer (repost)  

Posted by interes at Feb. 12, 2013
Inside the SQL Server Query Optimizer (repost)

Benjamin Nevarez, "Inside the SQL Server Query Optimizer"
English | ISBN: 1906434603 | 2011 | PDF | 272 pages | 5.7 MB

The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL queries into high performance execution plans in the blink of an eye through some unknowable process. The truth is that, while the Query Optimizer is indeed the highly-complex result of decades of research, learning how it works its magic is not only possible, but immensely useful to database developers and administrators alike. A better understanding of what the Query Optimizer does behind the scenes can help you to improve the performance of your databases and applications, and this book explains the core concepts behind how the SQL Server Query Optimizer works.

Dissecting SQL Server Execution Plans  eBooks & eLearning

Posted by kibitzer at July 31, 2009
Dissecting SQL Server Execution Plans

Dissecting SQL Server Execution Plans
Simple Talk Publishing (April 28, 2008) | ISBN: N\a | 252 pages | PDF | 3 MB

Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including which indexes are getting used and where no indexes are being used at all; how the data is being retrieved, and joined, from the tables defined in your query; how aggregations in GROUP BY queries are put together and the anticipated load, and the estimated cost.

Big Plans  eBooks & eLearning

Posted by alt_f4 at Dec. 2, 2016
Big Plans

Big Plans: The Allure and Folly of Urban Design (Center Books on Contemporary Landscape Design) by Kenneth Kolson
English | Jan. 4, 2002 | ISBN: 0801866790 | 257 Pages | PDF | 1 MB

Big Plans: The Allure and Folly of Urban Design springs from the idea that human aspirations for the city tend to overstate the role of rationality in public life.

Marketing de l'agroalimentaire - Environnement, stratégies et plans d'action  eBooks & eLearning

Posted by ALGEROIS at Nov. 28, 2016
Marketing de l'agroalimentaire - Environnement, stratégies et plans d'action

Marketing de l'agroalimentaire - Environnement, stratégies et plans d'action
Dunod | Aout 2016 | ISBN: 2100753665 | French | PDF | 452 pages | 79 MB

L'industrie agroalimentaire est l'un des premiers secteurs d'activité en France. Cet ouvrage met l'accent sur les spécificités du marketing du secteur agro-alimentaire : comportement des consommateurs, risque alimentaire et gestion de la qualité, marque propre et MDD…

Big man plans  Comics

Posted by ALGEROIS at Nov. 13, 2016
Big man plans

Big man plans
French | PDF | 114 pages | 142 MB

Excel BI - Power Query 2  eBooks & eLearning

Posted by naag at Nov. 11, 2016
Excel BI - Power Query 2

Excel BI - Power Query 2
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 42M | 214 MB
Genre: eLearning | Language: English

Excel BI - Power Query 1  eBooks & eLearning

Posted by naag at Nov. 10, 2016
Excel BI - Power Query 1

Excel BI - Power Query 1
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 12M | 122 MB
Genre: eLearning | Language: English