Gary Varga (2/3/2012)

---

Good question and one I'm glad you asked.

I'm the DBA on several databases, others I'm not. For those that I'm not the...

How embarrassing....

tsceurman (2/3/2012)

---

Until recently, I was using AS. I switched to using =, exactly because of the readability. Of course, I am also rather..... particular when it comes to...

IceDread (2/2/2012)

---

Because I could not let it go, I did some digging. This is what I found http://www.fas.se/upload/dokument/ALI%20pdf-skrifter/isbn9170453950.pdf

While one professor writes "software gets better with age but the...

SQL Kiwi (2/2/2012)

---

cengland0 (2/2/2012)

---

I like using this function for audit tables. If you have an application that allows users to add, edit, and delete, you can use this method...

TravisDBA (2/2/2012)The point is here that they are trying to move us away from the different flavors of syntax to a point where you can move SQL between the different...

Exactly. You don't need that information in the main table -- just the audit table.

Also, what would...

mtassin (2/2/2012)

---

KWymore (2/2/2012)

---

mtassin (2/2/2012)

---

cengland0 (2/2/2012)

---

I like using this function for audit tables. If you have an application that allows users to add, edit, and delete, you can use this...

I like using this function for audit tables. If you have an application that allows users to add, edit, and delete, you can use this method to keep track...

You know what's funny is some of the code I wrote over 10 years ago have the *= syntax instead of the joins. I now look at that and...

Really? I'd like to see that documentation. I'm...

jay holovacs (1/31/2012)

---

There has been research demonstrating that people tend to remember better when taking hand notes over keyboard notes. It appears that the kinesthetics of the motion helps...

Hugo Kornelis (1/31/2012)

---

Meh, I don't like questions where people who really understand the subject have a 50/50 chance of getting it right because they have to second-guess the author's intention.

"Is...

Interesting question.

If I'm at my computer and taking notes, I will use notepad so I can store it as a text file. I can organize those however I wish.

If...

djackson 22568 (1/30/2012)

---

I experienced something even worse than that! We do the same thing, almost exactly. When the results came back that showed unhappiness with the manager, it...