mtillman-921105 (9/21/2010)

---

Yeah Eric, I wish I could say that the last line of FoxPro code I wrote was in '98. I waited too long to switch over, but I...

Steve Jones - Editor (9/21/2010)

---

Does that...

mtillman-921105 (9/21/2010)

---

Eric Russell 13013 (9/21/2010)

---

mtillman-921105 (9/21/2010)

---

To what extent were relational DBMS created because drive space wasn't cheap and processing power was weak? Big, flat tables weren't helpful in either...

mtillman-921105 (9/21/2010)

---

To what extent were relational DBMS created because drive space wasn't cheap and processing power was weak? Big, flat tables weren't helpful in either case years ago. ...

Steve Jones - Editor (9/21/2010)

---

... We discarded MySQL and PostgreSQL for this site early on, even when funds were tight, because we weren't familiar with them and they were still...

David.Poole (9/21/2010)

---

The premise of NoSQL is that for applications where data loss is not the end of the world then the overhead of an RDBMS is overkill. They work...

I hope society never advances to the point where an understanding of relational set theory by the average person is required just to get by; most of our parents barely...

Whenever someone requests the creation of a new report, and the specifications don't seem clear or feasible (for example 50 columns fit upon an 11' landscape page), then I'll ask...

SKYBVI (9/17/2010)

---

@ eric

Ya, true , you have to give them a login and permission too.

About the refresh page, there is a option in connection properties,

refresh after __ minutes and also

refresh...

SKYBVI (9/17/2010)

---

Go to excel --> data

data -->other sources

-->sql server

-->new connection

write t sql script there

execute, the excel would be filled with the result

of the t sql specified..

no use of...

If users suddenly report that the database application is unresponsive, and you're looking for a first response script to tell you stuff like what connections are active, what processes are...

Most Oracle developers love cursors. I mean, it's so obvious they're in love. If you read an Oracle PL/SQL developer guide, it will be full of sappy love poetry dedicated...

The only practical way to report off of 5 million rows is to pull it into an OLAP cube, preferably on a different server or their local PC, and then...

There are a narrow range of data modeling scenarios where a...

Eric Russell 13013 (9/16/2010)

---

A BigInt datatype has max value of 9,223,372,036,854,775,807, so it's large enough to allow several tables to reserve an identity seed of several billion. If you're planning...