Jeff Moden (1/2/2010)

---

I've been "talking" with one of the proprieters of a web site that claims to be trying help people understand the idea of "set based" programming. I...

I think it's not possible to use the filestream API from SQL CLR code running in the same instance as the target filestream column. You can only use it to...

The only information you have mentioned in your description is Stores and Balances. So that sounds like just two columns in a single table. Maybe your actual scenario is more...

If low latency is essential then what's the reason for having two databases? Maybe you could just make sufficient bandwidth into the OLTP database so that it can be used...

A Data Warehouse should generally be designed to at least Boyce-Codd / 5th Normal Form. That is usually the best way to balance the requirements of flexibility, integrity, data loading...

They are not synonymous at all. A tuple is a set of named attributes - like...

Take the better example of a table whose key has three dimensions, the attributes (a,b,c), plus three other attributes (d,e,f). How to convert such a relation into a two dimensional...

roger.plowman (12/20/2009)

---

Access, for all that it's been maligned, is also a database, and with 90% of the features of SQL server. I've used it to develop and run the backbone...

It would enable more advanced optimisation of queries and data access. SQL database engines are much less...

And OO languages are just syntactic sugar! After all, everything can be done with machine code!...

Lynn Pettis (12/6/2009)

---

Until then, I really don't see what I can do to change things. I am not in a real position to influence what Microsoft, Oracle, IBM, or...

All keys are superkeys. Identifying a candidate key of a relvar is purely a matter of interpretation because it depends on what the intended meaning of the relvar is -...

Some examples:

P = PROJECT(a,b) R

If a is a key of R then a is a key...

Here's one I did using Rel (http://dbappbuilder.sourceforge.net/Rel.php)

// Create OrderItem and Order

VAR PurchaseOrder REAL RELATION {

OrderNum INTEGER,

CustomerNum...

Leaving aside the well-known disadvantages of procedural code, a trigger is not a substitute for a constraint because it does not enforce the rule. It allows the data to get...