SQLServerPedia

About 40 Blog Search Results

Showing 1 - 10

• The effects of DISTINCT in a SQL query | SQLServerPedia

  Jul 24, 2009 ... However, a new node has been added to the plan. A Sort node. This node is
  responsible for 75% of the total cost of the new query! ...

  http://sqlserverpedia.com/blog/sql-server-bloggers/the-effects-of-distinct-in-a-sql-query/

• Order By Does Not Always Guarantee Sort Order | SQLServerPedia

  Jul 17, 2010 ... The query plan between the two queries is identical, other than a sort vs. a
  distinct sort. Here is a small scale repro of the problem.

  http://sqlserverpedia.com/blog/sql-server-bloggers/order-by-does-not-always-guarantee-sort-order/

• SQL Server – Find the most expensive operations in Execution plans ...

  Jan 21, 2010 ... go through all the SQL Statements, get the attributes and sort on them ...
  Webcast Next Week – Using XML to Query Execution Plans I'll be ...

  http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-find-the-most-expensive-operations-in-execution-plans/

• Performance Tuning 101 – What You Will Not Learn In The Classroom ...

  Mar 8, 2010 ... The first query plan attribute I will look at is the clustered index ... Another
  method you can use to identify tempdb sort operations is ...

  http://sqlserverpedia.com/blog/sql-server-bloggers/performance-tuning-101-%25E2%2580%2593-what-you-will-not-learn-in-the-classroom/

• OVER Exposed | SQLServerPedia

  Mar 25, 2010 ... Since the DENSE_RANK() and the MAX() both do a PARTITION BY ProductID, their
  sorting requirements are exactly identical, and this query plan ...

  http://sqlserverpedia.com/blog/sql-server-bloggers/over-exposed/

• SQL Server Myths Debunked (Part 2) | SQLServerPedia

  Jan 20, 2010 ... As you can see, the only query that took advantage of query plan reuse ... While
  clustered indexes do physically sort the rows when they are ...

  http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-myths-debunked-part-2/

• Filtered Indexes Work-Around | SQLServerPedia

  Feb 1, 2010 ... Query processor could not produce a query plan because of the hints defined in
  ... if you're interfacing with any sort of external source. ...

  http://sqlserverpedia.com/blog/sql-server-bloggers/filtered-indexes-work-around/

• Down For The COUNT(*) | SQLServerPedia

  Sep 25, 2009... query plan. In fact, if you look under the hood at the (XML) query plan, ...
  Working from right to left, it essentially does a TOP 1 (with no sort order),
  ... If you take a look at the query plan for those 2 queries… ...

  http://sqlserverpedia.com/blog/sql-server-bloggers/down-for-the-count/

• Get Rid of RID Lookups | SQLServerPedia

  Aug 31, 2009 ... If you see an unexpected RID lookup in an execution plan, ... With Management
  Studio, RID lookups are displayed with the following icon (sort of … ... When
  you find an RID Lookup in a query plan, it's a symptom. ...

  http://sqlserverpedia.com/blog/sql-server-bloggers/get-rid-of-rid-lookups/

• Optimizing SQL Server Joins | SQLServerPedia

  Jan 27, 2010 ... (City_Cd); Wow, look at how the query plan changed. ... SQL Server gets an ANSI
  compliant unique index … sort of If you work with any of the ...

  http://sqlserverpedia.com/blog/sql-server-bloggers/optimizing-sql-server-joins/

1234