SQLRNNR (7/29/2015)

---

WayneS (7/29/2015)

---

BL0B_EATER (7/29/2015)

---

WayneS (7/28/2015)

---

I love it when I learn something in an area where I thought I knew it all.

You have made me very curious. What was the subject?

Table Variables. They automatically use a nolock query hint.

(Please Thread, don't smite me for posting code here...)

DECLARE @X TABLE (Col1 INT);

SELECT Col1

FROM @X

OPTION (RECOMPILE, QUERYTRACEON 3604, QUERYTRACEON 8607);

Oh and TF 3604 is typically used for certain console commands to output to screen. In this case, it is used to send the output of TF 8607 to screen.