Re: Oracle versus MS Sql Server

I rest my case m'lud.

Verdict: he hasn't a clue.

HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Michael G. Schneider" <mgs_at_mgs-software.de> wrote in message
news:9rf0mc$g68$01$1_at_news.t-online.com...


> "Jim Kennedy" <kennedy-family_at_home.com> schrieb im Newsbeitrag

> news:fTCC7.1931$ib.1140923_at_news1.sttln1.wa.home.com...

> > The question was what pctfree are you going to use when you create your

> > tables and what thought process will you go through to arrive at the

> number

> > for the particular table?  It is part of the create table statement.

You


> > had said you would issue all the create table statements etc.  that the

> > application you were writing needed.

>

> I did understand the question, but did you also understand my answer?

>

> Did you really want an answer? The question "which PCTFREE to use" is

almost


> as difficult to answer generally as was the question for which the answer

is


> 42.

>

> But if you want a real formula, here it is:

>

> - divide 13 by the number of NOT NULL columns

> - multiply it by the square root of PI

> - add "number of updates per minute" divided by "number of rows"

> - then add the number of VARCHAR2 columns

> - subtract the age of the database server

> - divide it by the number of full table scans per hour

> - multiply it with the number of flies in the room

>

> If you then arrive at a number between 0 and 99 (including), take it. If

> not, smash some flies and calculate again.

>

> Michael G. Schneider

>

>