Ahhhhh, that'll teach me not to read the create table statement properly. Yes, with a indexed computed column it makes perfect sense. I've actually used this trick accidentally when I...

Mind=Blown 😀

Do you...

I wonder if the confusion arises due to the ISNULL function being non-SARGable?

No. Not as simple as that I'm afraid. It depends...

Jeff Moden (10/8/2010)

---

Gianluca Sartori (10/7/2010)

---

Oracle RAC stands for Real Application...

There's no grid clustering solution for SQL Server, a single instance can only be part of a fail-over cluster.

You would have to implement your own method of running your...

I think everyone from Developers/BA's/Project Managers up to senior management dramatically underestimate the complexity of software development.

I often finding myself thinking that something will be easy and take a few...

Alvin Ramard (9/28/2010)

---

HowardW (9/28/2010)

---

... The irritating thing was it was about 3 weeks away from the QA stage so from our perspective it was virtually a finished product.

I hate...

I seem to remember something similar.

Ironically, when typing "70% development not used" into Google,...

Jeff Moden (9/28/2010)

---

Stefan Krzywicki (9/28/2010)

---

GilaMonster (9/28/2010)

---

Stefan Krzywicki (9/27/2010)

---

GilaMonster (9/27/2010)

---

Tom.Thomson (9/27/2010)

---

Sturgeon got it wrong. He should have said 95%. At least of the developers I have interviewed I regard...

It depends whether they literally select from that view on it's own using the same statement each time or whether they also join it to other objects/change the columns they...

Brian McGee-355525 (9/27/2010)

---

True Howard, except that in my case, the second table *didn't* have a column of that name, but when typing the query, I had thought that it did....

It's the same in 2k. Frankly I find the behaviour inconsistent and it's a common mistake.

If it will accept that an un-alaised column can belong to either the inner...

I'm not sure if you're referring to whether it will work against an Oracle or SQL Server data source? To_char and substr are oracle syntax - you need to look...

Thought I'd help you get to 20,000!

I think Gail "wins" with JHB - I've got some friends who work for Visa out there and it's the only place I've visited...