Steve Jones - SSC Editor (12/16/2010)

---

I think Intellisense can make this just as bad. If you're used to using "p", downarrow to get to ProductDetail and someone adds a new...

Lamprey13 (12/16/2010)

---

Anything you've read by Kimball should be forgotten. If you still have the book you read that in (assuming it was a book) you should burn it now to...

It would help if you provided the list of errors so we could help you better.

Daniel Bowlin (12/16/2010)

---

Ray K (12/15/2010)

---

sing4you (12/15/2010)

---

Cool! What are you playing?

I just sang, played piano, and bass guitar (not all at the same...

The key to keeping your throat from getting sore is to not swallow that stupid frog in the first place!

😛

Actually, the breathing thing I mentioned on page one of this...

GSquared (12/16/2010)

---

I used to know a DBA who insisted on using 1-letter aliases for all tables in queries, because it made them "faster to type" in the other parts of...

Dave Ballantyne (12/16/2010)

---

Sounds dangerously...

So, I have this query that yesterday is working fine and quick when I left outer join three tables. But when I change them over to inner joins takes forever...

Gianluca Sartori (12/16/2010)

---

Actually, dynamic SQL is the most efficient way to handle optional parameters in stored procedures.

Using COALESCE, ISNULL, CASE...

WayneS (12/15/2010)

---

CELKO (12/15/2010)

---

>> There's math problems with money? Please, do tell. I haven't heard anything about them and as I use that field [sic: columns are not fields] quite a...

CELKO (12/15/2010)

---

>> Now Microsoft may or may not have implemented COALESCE() by ANSI-Standards. I don't know. But given that no one can compare one unknown value (NULL) to another unknown...

Congrats, Tom. Remember to spoil her properly now.

WOTD: Spoil

Please start a new topic for your question.

I think I just found it. Money rounds funny when being used in division and multiplication.

Interesting that I never ran into this before. I should make a SQL Server question...

Not believing I'm actually going to get an answer to the question I posted on the thread Wayne just linked, I'm going to ask the question here.

Has anyone heard of...