THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Query Tuning   (RSS)
  • 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
  • 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
  • Geek City QUIZ: What happens when you change a column in an index from a key column to an included column?

    This quiz is not really a generic question about changing an index key column to be an included column; it's about a behavior noticed by a reader in one particular query.  Dejan Nakarada-Kordic from New Zealand sent me a very interesting puzzle. He had a reproducible query for which he thought an existing nonclustered index should be used, ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 24, 2008
  • 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
  • Did You Know: Can Query Tuning Become Unnecessary?

    I wrote a commentary for the SQL Server Magazine e-newsletter last week, and was expecting a to get a bit more feedback than I did.So I'm hoping my blog readers can help out.  I was commenting on a message that one of my business partners had sent out wondering about the changes that new higher speed storage technology might ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 7, 2008
Privacy Statement