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 2 of 3 (24 total posts)
  • 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
  • [New England] Kalen Delaney Internals and Query Tuning - in the Boston area October 12-16

    In case you missed Kalen's post, we're excited to announce that she will be joining us here on the East Coast in October to deliver her SQL Server 2005/2008 Internals and Query Tuning seminar. This is, to my knowledge, the most advanced public SQL Server course to be offered in the Boston area in the last 5 years, and this is the first time that ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 23, 2009
  • 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
  • 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
  • Medians, ROW_NUMBERs, and performance

    A couple of days ago, Aaron Bertrand posted about a method for calculating medians in SQL Server 2005 using the ROW_NUMBER function in conjunction with the COUNT aggregate. This method (credited to Itzik Ben-Gan) is interesting, but I discovered an even better way to attack the problem in Joe Celko's Analytics and OLAP in SQL.Rather than using a ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on December 18, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement