addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgoogleimageimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Execution Plans and the SQL Server Query Optimizer - Paul White, SQL Kiwi

​Effective T-SQL query tuning requires a​n understanding of SQL Server's query optimizer and the execution plans it produces.​ Join SQL Server MVP Paul White for an information-packed session covering both these crucial areas. The first part of the session will give you an overview of how the optimizer works, and what you can do to get the best from it. The second part covers the main things you need to know about execution plans, including some of the most common mistakes made when reading them. Everyone from novice to expert will find something new and interesting in this talk.

Join or login to comment.

  • Robert P.

    Paul was able to share his knowledge and be entertaining at the same time, hard to do.

    October 12, 2013

  • Sioban K.

    Paul is always an excellent presenter. A treat to get to see him.

    October 11, 2013

  • Robert P.

    Thank you, Paul White for taking the time to talk to us. It was not the easiest trip for him to get here, but it was most appreciated. I walked away with such good knowledge. Also, thank you to all that attended, looking forward to seeing you all next month. Don’t forget to checkout Paul’s slide deck and demo http://www.meetup.com/NESQLUG/files

    1 · October 11, 2013

    • Nathan

      Thanks to you and everyone that helped organize the event. It was a very informative presentation.

      October 11, 2013

  • Karthik K.

    Excellent presentation. Paul White is highly knowledgeable person and very nice too.

    October 11, 2013

  • Adam M.

    Paul's deck and demos are now posted in our files area.

    http://www.meetup.com/NESQLUG/files/

    4 · October 11, 2013

  • Ben C.

    I had signed up for this. Now I don't see my name on the attending list. What gives?

    October 10, 2013

    • Adam M.

      Hi Ben, we have no record of your ever having signed up. We certainly didn't remove you from the list. Next time please make sure that your name appears on the list on the righthand side.

      October 11, 2013

  • manish b.

    awesome. needed lot more time.

    October 10, 2013

  • Rabindra A.

    great .

    October 10, 2013

  • Nathan

    Damn, thought I signed up for this. Oh well, hope I can be added to the wait list.

    Thanks.

    October 10, 2013

  • Ardo P.

    Will there be pizza provided or should we plan on grabbing some food before we arrive?

    October 10, 2013

    • Adam M.

      We will have pizza.

      1 · October 10, 2013

  • Lavanya P.

    Same here I thought I was in and right now on waiting list. Is there any means to know if we could join before 4pm so that I can plan out to leave work and head towards Cambridge

    October 10, 2013

    • Jason P.

      Parking is tough in that area. If you're driving in from outside the city you may want to park at Alewife and take the red line to Kendall.

      October 10, 2013

    • Adam M.

      Please see our parking info page: http://www.meetup.com...­

      October 10, 2013

  • shwetha s.

    Hi Adam,
    I am very much interested in attending today's session.
    Can you please put me on waiting list?

    Regards
    Shwetha

    1 · October 10, 2013

  • Adam M.

    The list is now locked down. Looking forward to seeing everyone in a few hours.

    October 10, 2013

  • Adam M.

    We have now closed RSVPs on this event. If you can no longer attend, please remove yourself from the list in order to let someone from the wait list get through.

    If you're looking for a job or hiring, consider stopping by a bit early (starting at 6:15) to have a chat with our sponsor, Huxley Associates. Bring your resume if you'd like a critique!

    See you all tomorrow evening.

    October 9, 2013

  • Sioban K.

    What is the capacity of the room? This is the first time I've seen a waitlist for one of these meetings (the first time we've used Meetup for it). How does the waitlist work?

    October 8, 2013

    • Adam M.

      Hi Stefan, we've had a waitlist once or twice in the past. (Mark Souza last year being one time.) This one is just a bit more official and controlled thanks to Meetup's system. We'll e-mail the attendees later and ask people to remove themselves if they can no longer attend, so I suspect people in the waitlist will move onto the attendee list.

      October 8, 2013

  • Katie D.

    Looking forward to my first meet up with this group.

    October 7, 2013

  • alan s.

    How do Common table expressions perform as compared to old-fashioned views and queries?

    October 1, 2013

    • Rabindra A.

      Hi Sir,Common Table Expressions can help it .

      October 6, 2013

  • Chris

    Awesome !

    October 5, 2013

  • Paresh Motiwala P.

    Guys look forward to meeting you all.

    October 4, 2013

  • Rabindra A.

    I am coming

    October 4, 2013

  • Eyalarasan

    I will be attending the Execution Plans and the SQL Server Query Optimizer Session
    - Eyal.

    October 3, 2013

  • Ardo P.

    I am very pleased to see that you are now using Meet-Up to organize the NESQLUG meetings.

    October 2, 2013

  • Robert P.

    If you want some "light" reading check out Paul's blog at http://sqlblog.com/blogs/paul_white/default.aspx

    3 · October 1, 2013

  • Adam M.

    All, please set your display name to your FULL NAME. We can't use first names only due to our building's security requirement.

    1 · October 1, 2013

  • Karthik K.

    Your articles are awesome!

    1 · October 1, 2013

  • Travis M.

    Travis McGee

    October 1, 2013

  • Adam M.

    @alan spillert

    CTEs can be thought of, effectively, as query-scoped views. They are optimized similarly to derived tables.

    1 · October 1, 2013

Our Sponsors

  • Paessler

    SQL Server Monitoring made easy with PRTG Network Monitor.

  • Vision Solutions

    The premier provider of IT software solutions.

  • PASS

    $150 OFF PASS Summit 2016 registration use code: LC15TVF9

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy