30th September - 2nd October 2010

University of York

RSS
Login or Join
Skip Navigation Links
Skip Navigation Links
Home
SQLBits 7
Register
Agenda
Booking & Pricing
Training Day
Friday
Sessions
Speakers
FAQ
Travel & Accommodation
Sponsorship
Gold Sponsors
Exhibitors
News
Previous Events
SQLBits The 6th Sets (VI)
Sessions
Speakers
SQLBits goes West (V)
Sessions
Speakers
SQLBits goes Forth (IV)
Sessions
Speakers
SQLBits Cubed (III)
Sessions
Speakers
SQLBits II The SQL
Sessions
Speakers
SQLBits I
Sessions
Speakers
About
About SQLBits
Who's Who
Privacy
Contact
Community

Brought to you by the UK SQL Server Community.

Copyright © 2007-2010 SQLBits. All Rights Reserved.

Telerik

Orcsweb

Gold sponsors
    
Silver sponsors
    
Bronze sponsors
    
    

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.

 

Speaker focus

Simon Sabin

ss03_small.jpg
Simon is an independent Database consultant specialising in the world of search, distributed architectures, business intelligence and application development. He has worked with SQL Server since 1998 and has always focused on high performance reliable systems. He was awarded as an MVP in 2006 and is regular speaker at SQL Server events as well as writing for SQLServerCentral and Simple-Talk.com.

Simon Sabin's blog http://sqlblogcasts.com/blogs/simons


Downloads

File Type Ext ContentName
Presentation .pptx Presentation
Presentation .pptx When query plans go wrong.pptx
<< 1 >> 

Other sessions from this conference

A whistlestop tour of SSIS add-ins
Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study
An introduction to Master Data Services
Building cubes from ODS or Operational Systems
Cache-warming strategies for Analysis Services 2008
Common Integration Services Problems
Creating High Performance Spatial Databases
Data & Backup Compression in SQL Server 2008
Data Visualisation with Bing Maps for Enterprise
Data Warehouse on a Fast Track forwards
Data warehousing features in SQL 2008
Designing for simplification
Designing I/O systems for SQL Server
Excel - An Excellent Data Mining Tool
Getting Dimensional with Data
I need my reports..........Yesterday!
Introducing Project Madison
Introducing SQL Server Master Data Services
Introduction of MS StreamInsight.
Introduction to the Microsoft BI Technology Stack
Let’s make SQL fly – a technical session for developers and administrators who believe in magic!
Lets go more functional - F# WHAT , WHY and BI
Microsoft SQL Server 2008 R2: What’s New in Reporting Services
Optimistic Concurrency Internals
Powershell – old tricks for a new dog?
Put Your Feet Up : Simplified Management using the Enterprise Policy Management Framework
Real World SQL Server High Availability
Report Builder 3
Self Service Business Intelligence- Project Gemini
Server consolidation with SQL Server
SQL 2008 Development Features
SQL Injection Attacks (and how to prevent them)
SQL Server 2008 - Unstructured Data Storage Solutions and Best practices
SQL Server optimization stuff you won’t find on Google (yet)
SQL, NoSQL, SomeSQL - A look at non-relational databases
SQLDataSources, LINQDataSources and EntityDatasources in Database Design
SSIS in SQL Server 2008
Strapped for cache? - Troubleshooting memory problems in SQL Server 2008
The R2 Duo: Running SQL Server 2008 R2 on Windows Server 2008 R2 Core
T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The Stig
Using Perfmon and Profiler
Virtualising SQL Server
Vital Statistics
What's new in R2 for the DBA