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
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.