DIR Return Create A Forum - Home
       ---------------------------------------------------------
       ExcelSoft Database Professionals
  HTML https://esdbp.createaforum.com
       ---------------------------------------------------------
       *****************************************************
   DIR Return to: General
       *****************************************************
       #Post#: 91--------------------------------------------------
       Identifying and Solving Sort Warnings Problems in SQL Server
       By: srinivasma_exceldbp Date: November 6, 2014, 4:43 am
       ---------------------------------------------------------
       Sorting is one of the resource intensive operations in  SQL
       Server . Sorting occurs  due to the use of DISTINCT,ORDER
       BY,GROUP BY or  on join columns which don't have index,
       parameter sniffing etc . Sort operator is a blocking operator.
       Unless all rows are collected sorting can not go through. This
       blocks the query and also other queries in the server . So use
       the above operator judiciously and DO NOT use DISTINCT/GROUP BY
       on large set of columns or columns of large size like
       varchar(100), nvarchar(100), varchar(max) . If possible push
       sorting to middle layer
       Check the attached document to solve sort warning issues
       *****************************************************