Rob Reid-246754 (6/3/2015)

---

Regarding the GOTO statement, are people saying it has no place in TSQL either?

I know VB and remember on my Amstrad 64 having to use GOTO statements...

Alan.B (6/1/2015)

So here's what's the takeaway here? It's better for an update to run for several extra seconds to prevent a several hundred ms blip for a single user? Rhetorical...

Alan, totally agree with you that "it always comes down to performance". I threw together a quick and dirty example to illustrate...

While I agree that cursors can (and should) be avoided most of the time, it is not ideal to utilize set-based operations in all cases. Especially in very-large OLTP...

...and ice cream

Process of elimination worked for me too... but slightly different logic.

I thought 3 was the only one that would definitively result in a NC scan. This left answers (1,3)...