I didn't say random access couldn't be done, I just said that an RDMS doesn't really lend itself to random access. Am I wrong?

And there is nothing intrinsically wrong with...

Maybe you could post some sample data and a sample of what you want the output to look like.

Well, good grief, this wasn't even past the proof of concept stage. I don't think OP was concerned at this point about performance. He seemed more interested in seeing if...

Don't use triggers. Use a identical stored procedure on each server to perform the insert. When your app writes data to the table, it does so by executing the sproc...

A relational database doesn't really do random well. Here are a couple of more straightforward solutions. If you want truly random results from one query to another -- good luck.

CREATE...

select topicID, lastPosterID
from tbl
where postDate = (select max(postDate) from tbl)

The problem is that, unless you truncate the dates when entering them into the table, you will still only return the...

If the intersection table is being used in other relationships besides the M:M relationship between Vendor and Product (as in Ninja's example), then it may make sense to create an...

Well, I see you've managed to create a circular reference to yourself.

• I don't know what database analysis tool the guy used so I can't comment on its accuracy.
• I don't know...

I'm not really sure that char(39) is any easier to read than ''''. It's been a few years since I've had to break out an ASCII chart.

Mostly DBAs? You're kidding. The people here are too knowledgeable and helpful to be DBAs.

You guys have come a long way over the last, oh, ten years or so.

A procedure I use to make sure I get all the nested quotes right. First, type the string just as you want it to be:

Select * FROM table1 WHERE col1...

Ah, well, in the example you give, you are violating 1NF. Break the one column into TenderNo (if needed), BuyerID, FinancialYearID and TenderType columns. The TenderNo column would be needed,...

Strings in C# (and Java) are immutable. That is, once created, they cannot be changed. Usually, when you instantiate a class, you create a default object with the intent of...

True -- each attribute or column value must be atomic for 1NF. However, a key may or may not be atomic and normalization rules do not require it.

If a PK...

In thinking back on it, the ad specifically mentioned only programming skills and duties. It's like they needed a programmer but they just couldn't bring themselves to offer a job...