THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Query Tuning   (RSS)
Showing page 1 of 3 (22 total posts)
  • SQL Saturday Chicago (#291) - Clash of the Row Goals - Demos

    Thank you to everyone who joined me today at SQL Saturday Chicago for my ''Clash of the Row Goals'' session. I'm honored that so many people would attend a talk with such an incredibly arcane title -- and always glad to find a curious, interested, and intelligent audience. The demos I showed during the session are attached to this post. If you ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 26, 2014
  • SQL Saturday Chicago...and the Gentle Art of Planscaping!

    Three weeks from now I'll be visiting Chicago to participate in SQL Saturday. I'll offer two different learning opportunities: On Friday, April 25, you can join me for a full day seminar on parallelism and performance in SQL Server. This class covers in-depth background on the hows and whys behind SQL Server's parallel processing, followed by an ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 2, 2014
  • Demos: SQL Saturday Boston (#262) - Clash of the Row Goals!

    Thanks to everyone who joined me yesterday afternoon in Cambridge for my Clash of the Row Goals talk. It was great to receive such a welcome reception for a rather out there topic. Three things I should clarify for those who attended:The Many() function appeared to create an invalid estimate in one case; but that was due to auto-parameterization ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 30, 2014
  • SQLRally Nordic and SQLRally Amsterdam: Wrap Up and Demos

    First and foremost: Huge thanks, and huge apologies, to everyone who attended my sessions at these events. I promised to post materials last week, and there is no good excuse for tardiness. My dog did not eat my computer. I don't have a dog. And if I did, she would far prefer a nice rib eye to a hard chunk of plastic. Now, on to the purpose of ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on November 11, 2013
  • Query Tuning Mastery at PASS Summit 2012: The Video

    An especially clever community member was kind enough to reverse-engineer the video stream for me, and came up with a direct link to the PASS TV video stream for my Query Tuning Mastery: The Art and Science of Manhandling Parallelism talk, delivered at the PASS Summit last Thursday. I'm not sure how long this link will work, but I'd like to share ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on November 13, 2012
  • Query Tuning Mastery at PASS Summit 2012: The Demos

    For the second year in a row, I was asked to deliver a 500-level ''Query Tuning Mastery'' talk in room 6E of the Washington State Convention Center, for the PASS Summit. (Here's some information about last year's talk, on workspace memory.) And for the second year in a row, I had to deliver said talk at 10:15 in the morning, in a room used as ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on November 11, 2012
  • SQL Saturday 111: Manhandling Parallelism - Demos

    Another year, another fantastic Atlanta SQL Saturday. Hats off to the team that created the event for delivering a top notch day for the attendees. Thanks to everyone who attended my ''Query Tuning Mastery: The Art and Science of Manhandling Parallelism'' session. Demos are attached. Enjoy, and I'll see you at the next one!
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 15, 2012
  • PASS Summit 2011 - Zen and the Art of Workspace Memory - Demos

    What a rush. Standing on the stage in an almost-full 1,000-person room, I (very) momentarily wondered what I'd been thinking when I submitted a 500-level talk for the biggest SQL Server conference in the world. But despite a rough start--my laptop crashed and I had to reboot it two minutes into the talk--I found my rhythm and the entire 90 minutes ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 16, 2011
  • T-SQL Tuesday #13: Clarifying Requirements

    When we transform initial ideas into clear requirements for databases, we typically have to make the following choices:   Frequent maintenance vs doing it once. As we are clarifying the requirements, we need to determine whether we want to concinue spending considerable time maintaining the system, or if we want to finish it up and move on ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on December 13, 2010
  • Did You Know: My next web seminar is this Wednesday!

    I know, I haven't made a geeky post in a while... but I promise that I'll do one after this seminar. I'll take some of the best questions that I get during the chat and write them up here. Query Plans Workshop (June 30, 2010) Learn about basic elements, tools for exploring your query plans, how to detect inefficient plans and best practice ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 27, 2010
1 2 3 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement