James Stephens (12/1/2010)

---

My original beef with isNumeric() was the single characters that returned 1. For example, a dot is not a number. Period. It's not "numeric". ...

Maybe you have the plans misnamed, but "Without_repl_predicates" shows an Index scan (IndexScan Ordered="true") and the other plan shows the opposite??

Anyway, while I'm playing with this, try doing the first...

Greg Edwards-268690 (12/1/2010)

---

Brandie Tarvin (12/1/2010)

---

There are no really good standards for a...

Because you've got them all lumped together??? To my eyes, the code should say:

...

Gianluca Sartori (12/1/2010)

---

How can

AND ({fn ISPALUSER('23320088-BB3F-46AC-905D-0F2A95181934')} = 1

...

I don't see ISPALUSER in BOL. Can you script that function out for me?

GSquared (12/1/2010)

---

Which reminds me. Jack, I work in Orlando now. Let me know if you want me to present anything to your group again this winter. Was...

GilaMonster (12/1/2010)

---

Ask? What is this ask? I'm a consultant. "As of Jan 1st, the new hourly rate will be...

Yes and no. The way that slowly changing dimensions are implemented in...

GilaMonster (12/1/2010)

---

You know there's a problem when...

In the last 2 weeks there have been three resignations at current client:

The senior developer (leaving only 2 permanent developers)

The Chief Enterprise...

I'm not sure I understand your question.

If you test it, ISNUMERIC() will come out as true for...

Tom.Thomson (12/1/2010)

---

The 744 pixel wide image doesn't really fit well unscaled in a 670...

Even people who think they know should read this article. I actually knew all about the punctuation and currency signs, but then I got to the "e" and "d" part....

lemon

GilaMonster (11/30/2010)

---

GSquared (11/30/2010)

---

If it were written:

SELECT ..

FROM T1

inner join T2

on T1.a >= T2.b

inner join T3

on T1.a <= T3.c;

Would you still question it? It's the same...