option for hint Option(Robust) | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

option for hint Option(Robust)

Is there another option for the below apart from using OPTION(ROBUST) since this seems to be affecting perormance.The stored procedure that casuses this loads things from the db. Cannot sort a row of size 8416, which is greater than the allowable maximum of 8094.
maybe this article will give you some ideas: http://www.sql-server-performance.com/hints_query.asp
YEs you can use OPTION ROBUST PLAN in this case that will not let optimizer to choose any query plans. http://www.aspfaq.com/show.asp?id=2400 fyi too. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
]]>