I am currently doing a review of my personal database naming
conventions and found that there are not much (good) examples in the
literature for some special objects. Certainly there are bigger issues
in a database project that that, but I would like to try cleaning that

I've got a customer who wants reproducible/historical reporting.  The
problem is that the underlying data changes.
I tried to explain that this can't be done (can it?), but he doesn't
understand.

is there a way to undo changes in a database (e.g. those made because of
a recent human error, an erroneous delete/update query)
For example reversing all transactions made in the last N days?
On any database? In particular I am most interested in postgres and

I have a number of "clients" which report with a string
"client_id,client_model,0001001001", when the third part is a binary
string containing client's status. Each client model can have various
status message length and interpretation.

Out of curiosity, can every LEFT JOIN be rewritten as a query with
RIGHT JOINs?  It seems to me that if you just take the "leftmost"
table and use that in the FROM part of a SELECT that all subsequent
LEFT JOINs would need to be RIGHT JOINs...

Secure Auditor is a network based database security assessment tool
capable of scanning multiple Oracle database servers. Secure Auditor
addresses the critical issues like Access Rights, Weak Passwords,
Default Passwords, Access Control, Audit Policies, Roles,

Hi guys;
I have a hierarchical structure represented in a database with child
nodes having a foreign key to their parent. I'm wondering how to
create a constraint on uniqueness of a "name" attribute on that

I know generation of SDF files.
Sequential data without delimitors, zero padding etc.
Now, I have to generate ascii file with extension "txt" and delimitor
^

I'm researching two-way conversion methods available for converting
between the constructs in the relational data model (i.e., the
relations) and those of logical databases (e.g., Datalog-based
databases).  I'm aware of the basic mappings between the intensional

which statement will take more processing time in SQL Server?
(A)  Insert
(b)  Update