Grant Fritchey (1/26/2009)

---

Risking a pork chop, I'm going to disagree with Jeff on this.

You should look at option 1, but as was mentioned before, create a schema for the views....

Heh... if it's not in the "SQL Dictionary", I usually don't get it, either. I learned one just recently that very well describes some of the source of "flames"...

GilaMonster (1/25/2009)

---

Jeff Moden (1/25/2009)

---

The ironic part about all of this is that very example actually strengthens the argument that the quirky update does always work as advertised. I'm going...

Sorry folks... I got busy on other stuff. I'll take a look and see if I can answer some of the questions folks directed at me, tonight.

My absolute favorite standard is "MIL-TP-41".... "Make It Like The Print for once". 😛

Thanks for the feedback. And, as you can see, avoiding RBAR is quite a hot topic with most of the power users.

GSquared (1/26/2009)

---

Jeff, something I have to ask:

You keep mentioning that recursive CTEs are worse than cursors. I can see that in some cases, but in cases like a hierarchy...

Just convert to INT and you're done...

Cool... thanks.

Thanks for the links, Johan... I'll take a look (am I spelling your name correctly?)

Whew! Thanks for the feedback, Jon... thought you were falling on a sword and didn't want to see that happen. 🙂

jan michael woo cerna (1/25/2009)

---

hi jeff, thanks for the adviced. I'm working on a large data for a particular client. Are there any other options w/o using a...

Guess I'll be the one to break the "real" ice on this thread...

It's not an answer on a thread that I really messed up on... no... it's much worse. ...

I'm not sure its "bad" advice in that lots of folks do get this information from the internet but never test it. Shoot, I'm in the process of fixing...

I'm pretty sure you need at least DBO privs to do a SHOWPLAN.