null

Jeff Moden (1/28/2016)

---

I've found that many technologists that are in the business of writing code don't understand the extreme ROI of commenting code properly. In a previous company where...

For each revision to a DDL script, prior to check-in, I include a new entry in the header with the date, with CO number, developer's name, and brief one line...

J Livingston SQL (1/29/2016)

---

hehe....had never used it, til now.........cant see the point

...

...

CReAte tABle mytable(TranID INTEGER nOt...

J Livingston SQL (1/29/2016)

---

hehe....had never used it, til now.........cant see the point

...

...

CReAte tABle mytable(TranID INTEGER nOt...

This reminds me of those two or three occasions, as a teenager, when I would return home with damage to my dad's car. Providing too much information isn't useful in...

First, when it comes to agreeing to a standard, I suggest that you not argue over minor details and instead come to an agreement about functional issues that matter (like...

When inheriting a legacy database with little documentation, one thing I do is start creating views as I learn the purpose and usage of the tables. For example, I may...

xsevensinzx (1/29/2016)

---

Eric M Russell (1/28/2016)

---

On the flip side, as a job seeker you should also be suspicious of "opportunities" which seem to always be available. For example, there are some...

Yes, by necessity the role of a typical DBA is changing. If you work in a massive hosting data center with dozens of DBAs, then maybe you can get by...

A session can be held for an extended period of time in a wait state without being blocked by another session. For example, it could be a complex and long...

On the flip side, as a job seeker you should also be suspicious of "opportunities" which seem to always be available. For example, there are some employers who advertise for...

Bill Talada (1/27/2016)

---

And Eric...how is it that foreign keys are a performance penalty, other than one time at insert? Don't they provide information to the optimizer to make queries...

Charles Kincaid (1/27/2016)

---

Actually FKs for the purpose of documentation only seems like a bad idea.

The...

mjh 45389 (1/26/2016)

---

Eric M Russell (1/26/2016)

---

Alan.B (1/26/2016)

---

Ivanova (1/26/2016)

---

...

In the past 6 years I have worked with several guys in their 50s, 60s, 70s including an excellent 79-year old (today)...