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 » performance » Query Tuning   (RSS)
Showing page 1 of 2 (15 total posts)
  • 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
  • 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
  • Automating dm_exec_query_stats and dm_db_index_usage_stats analysis

    Everyone should know by now how really useful the DMVs dm_exec_query_stats, and dm_db_index_usage_stats and the associated DMFs for obtaining the SQL and XML plan: dm_exec_sql_text, dm_exec_query_plan, and dm_exec_text_query_plan. Of course it has been explained that dm_exec_query_stats is not a replacement for SQL Server Profiler and SQL Trace. ...
    Posted to Joe Chang (Weblog) by jchang on June 22, 2009
  • Why Logical IO is a poor performance metric

    Many years ago, I attended a conference where a very highly respected Oracle performance expert advocated the use of logical IO count as a performance metric. The argument was that a logical IO is a fairly substantial operation relative to others. I suppose that detailed logical IO was already collected supported this. So why would logical IO be ...
    Posted to Joe Chang (Weblog) by jchang on September 10, 2008
  • SQL Server Query Processing Puzzle: LIKE vs ?

    How creative are you with manipulating your queries to produce more efficient plans? Try the following puzzle and e-mail your solution to me at [<do_not_mail> @ do_not_mail.com]. Make sure to include an explanation of why it works, as well as your mailing address. The best two solutions/explanations win a free copy of Expert SQL Server 2005 ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 22, 2008
  • Who's On First? Solving the Top per Group Problem (Part 1: Technique)

    Relative comparison is a simple matter of human nature. From early childhood we compare and contrast what we see in the world around us, building a means by which to rate what we experience. And as it turns out, this desire to discover top and bottom, rightmost and leftmost, or best and worst happens to extend quite naturally into business ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on February 8, 2008
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement