mrpolecat (3/28/2008)

---

You would have a table that contains the computerid and the softwareid with a record for every piece of software that is installed on each computer. You would...

dfalso (3/28/2008)

---

You guys and your fancy SQL 2005 functions...:hehe:

That's a nice one. How's the performance vs. something...

dfalso (3/28/2008)

---

What, you want answers too? 🙂

Well, assuming you have an integer-ish rowid field on the table, MOD it by...

I'm drawing a comparison (or rather - highlighting the difference) between...

Robert (3/28/2008)

---

Matt Miller (3/28/2008)

---

In the case of an un-indexed view, the view is never compiled on its own. The text of the VIEW gets inserted into the outer query...

ACtually - I do find that EXISTS often enough works better.

It's a bit of a "it depends", but I tend towards EXISTS rather than IN unless the "IN"...

Actually - no. Not for views.

In the case of an un-indexed view,...

peitech (3/28/2008)

---

Thanks Piotr Rodak - I tried the example you posted and it makes perfect sense to me now.

Seems odd that it works fine with 'in' but doesn't with...

Lars Huttar (3/28/2008)

---

On the other hand, taking 3-valued logic to its logical conclusion, S3 just postpones the inevitable one step. If we represent S3 as

NOT(NULL = anything) AND NOT(NULL <>...

Keep in mind that "max" works against non-numeric values too.

The right "group by", would definitely handle it.

In 2005, you could use another approach as well.

SELECT A.ID,

...

Lars - the issue you seem to be hammering on stems from treating NULL as if it were a value. NULL is technically not a value, so any comparison...

Mike C (3/28/2008)

---

I'd agree that this is probably a common usage, and as long as you're comfortable with using NULL to represent multiple states that might be adequate. The...

Jeff Moden (3/28/2008)

---

Good article... and I realize it's a couple years old...

I normally don't work NULLs against "TRUE/FALSE" values even in WHERE clauses... I normally work them against some form...

Notice that what Grant and Piotr are both trying to improve on is the "lookup" part of the process.

That's because you can't use a single operation to insert...

I'd say you're right. IMO - it doesn't "buy" you anything to have multiple volumes in the same RAID set. Performance-wise, you haven't changed the number of spindles,...