Skip to main content
corrected flag number based on linked article
Source Link
Mark Sinkinson
  • 10.6k
  • 4
  • 46
  • 54

Quick guess: enable trace flag 43194139.

You are already running SP2-CU1 so this should work

Note the guidelines about TF 2389 ad 2390 too and also see http://sql-sasquatch.blogspot.com.mt/2013/06/mssql-plan-guides-to-address-ascending.html

(Note, I've not really hit this problem and have not dived in that deep)

Quick guess: enable trace flag 4319.

You are already running SP2-CU1 so this should work

Note the guidelines about TF 2389 ad 2390 too and also see http://sql-sasquatch.blogspot.com.mt/2013/06/mssql-plan-guides-to-address-ascending.html

(Note, I've not really hit this problem and have not dived in that deep)

Quick guess: enable trace flag 4139.

You are already running SP2-CU1 so this should work

Note the guidelines about TF 2389 ad 2390 too and also see http://sql-sasquatch.blogspot.com.mt/2013/06/mssql-plan-guides-to-address-ascending.html

(Note, I've not really hit this problem and have not dived in that deep)

Source Link
gbn
  • 70.1k
  • 8
  • 165
  • 242

Quick guess: enable trace flag 4319.

You are already running SP2-CU1 so this should work

Note the guidelines about TF 2389 ad 2390 too and also see http://sql-sasquatch.blogspot.com.mt/2013/06/mssql-plan-guides-to-address-ascending.html

(Note, I've not really hit this problem and have not dived in that deep)