When a query plan goes wrong with Simon Sabin

powered by SQL SERVER 2012

Platinum Sponsor

Fusion-io

Booking & Pricing

Travel & Accommodation

Platinum Sponsor

Previous Events

SQLBits Query across the mersey

SQLBits Beside the seaside

SQLBits 7 Wonders of SQL

SQLBits The 6th Sets (VI)

SQLBits goes West (V)

SQLBits goes Forth (IV)

SQLBits Cubed (III)

SQLBits II The SQL

Copyright © 2012 SQLBits. All Rights Reserved.

Gold Sponsors

Silver Sponsors

Bronze Sponsors

Community Sponsors

It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Quest Software

When a query plan goes wrong

This session looks at some of the common scenarios when query plans can go wrong leading to your performnce suddenly hitting the wall.
We will talk through

what happens
why it happens
ways in which you can avoid it happening.

Presented by Simon Sabin at SQLBits V

Downloads

Slide Deck 611 KB

WMV Video 211 MB
SpeakerBIO

Simon Sabin

Simon is Head of Data at Wonga.com. Prior to Wonga Simon ran a SQL Server Consultancy specialising in performance and scalability. He has worked with SQL Server since 6, became an MVP in 2006 and in 2007 founded SQLBits. He is also a SQL Microsoft Certified Master. You can follow him @simon_sabin or read his blog http://sqlblogcasts.com
Video

Click here to view in local media player
Session Files Explorer
{1}

##LOC[OK]##

{1}

##LOC[OK]## ##LOC[Cancel]##

{1}

##LOC[OK]## ##LOC[Cancel]##
When_a_query_plan_goes_wrong
Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.