Currency symbols are a form of formatting... and that's a form of "Death by SQL". You shouldn't ever store formatted data in a database. Formatting should either be...

First, I would post my question on an Oracle forum... all of these forums are for MS SQL Server or Access...

Thanks, JP...

colin Leversuch-Roberts (2/25/2008)

---

I never understand why it's assummed that a simple query from a view ( which is probably complex ) will work well. Forget your views and expand the...

Jeremy Giaco (2/28/2008)

---

Jeff Moden (2/28/2008)

---

Yes, they both "utilize" the index... but how? I think you'll find that utilization is limited to an Index SCAN and that you cannot get...

Ian Yates (2/28/2008)

---

I second Andras - I'm wary of software that absolutely requires the columns be in exact order due to their use of select * in queries and then...

With as often as I've seen folks refer to it, we should all put the Forum Ettiquette link in our signature. I'll mod my sig tonight. Thinking about...

Oh yeah... that's it... oh... no, wait... I was thinking of just "flakes"... wrong show 😀

jeremy.giaco (2/28/2008)

---

I liked the article, but I don't seem to have the problem with my queries that you are describing when using functions like IsNull in the where clause. ...

Um... star schema's? Isn't there a sidewalk like that somewhere in Hollywood? 😀

Ian Crandell (2/28/2008)

---

Thanks for the info. I have seen you use or refer to the tally table in many of your posts and now that I read this I...

I suspect they're really meant to find out if you actually know SQL Server or not. :P...

I'm curious, Mark... what position were you applying for?

Matt Miller (2/28/2008)

---

I'm thinking he means that if you persist the computed column, you can then include it in the index being used to optimized the query. saves all...

Ummmm.... not sure what you mean by an "index computed column".... how does...