Those seem like fair and basic questions.

Phone screening is a step in the right direction. Ask a few questions like those over the phone, you'll eliminate a huge number...

Gaby Abed (7/9/2009)

---

For all you lovers of English, here is a sentence without punctuation:

that that is is that that is not is not that that is not is not that...

Learning consists of doing. Studying is just a precursor to that.

So, I recommend working out some way to DO database work. If writing/tuning queries is your thing, check...

I use a database called "Common" for that kind of thing. Keep a Numbers table and a calendar table in there as well as any procs or UDFs that...

There are theoretically unbreakable codes, but not cyphers.

For example, if I tell you that the phrase, "the bear is in the woods", means, "blow up Moscow now", and you and...

Lynn, "maple data"???

I hadn't seen that bug. Good to know about.

Jeff Moden (7/8/2009)

---

So what's the advantage to prefixing every table name with "tbl"? I see it as a disadvantage just because it requires more typing. If someone with...

Any primary key that relies on human names is inherently flawed.

In my case, my legal first name is "Richard", but I go by an abbreviated form of my middle name,...

-- Bugs on the page creating duplicate posts

Jeff Moden (7/8/2009)

---

GSquared (7/8/2009)

---

Like I said, pick a standard and stick to it. In this case, that matters more than what the specifics of the standard are. The...

The main problem with solutions that make data secure, is that they also make data losable.

If, for example, only one person knows the key to the data, and that person...

I prefer lowercase for keywords, propercase for objects.

Just more readable to me.

Distinctly dislike uppercase. It's not used in common print because it's less readable. Lowercase letters were invented...

I use tabs because that allows me to copy to Word when I'm documenting stuff, and I can adjust layout by adjusting the tabs on the "ruler".

Advantages/disadvantages to either way...

I've built plenty of high-performance, extremely functional databases without these two features.

I don't see what you're talking about as "hacks". I see them as ways for me to have...