Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Fri Feb 7 08:59:00 CST 2003
hi Charles, hmm.. both acees, and excel, + vba knowledge, sql, powerpoint (haven't done anything on it, and am not really dying to). Most of the time I just do reports using their own applications, and applications they've livensed. Plus some minor financial analysis; talking to traders, etc. Well, its' NY, one person does 3 people's work :) in I don't usually develop applications, ony various forms to do reports,send mail, export data to excel and reports there, get data from parodox and other sources, etc There's no maintanance here since i am not part of it/development/system group. Same was the case at my last job. I don't know whether I'll be here in 6 months, dunno about Texas, but in NY unfortunately nothing is certain. > Oleg, > > Did they hire you to develop databases or to develop spreadsheets? If > you plan on being there six months from now when maintenance will be > required, then do it the right way. If you want to get a reputation for > developing bad applications, then do it the way you boss says. > > Charles Wortz > Software Development Division > Texas Education Agency > 1701 N. Congress Ave > Austin, TX 78701-1494 > 512-463-9493 > CWortz at tea.state.tx.us > (SELECT * FROM users WHERE clue > 0) > > > -----Original Message----- > From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] > Sent: Thursday 2003 Feb 06 13:44 > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Maximum number of columns in a table ? > > Charles, I ofcourse agree with Fransisco, and Jeff Putnam who wrote the > article. But that's how they want this, i was just checking if 70 > columns may caz problems, frankly I've never seen a table like that. I > am not running the company and I ca't really input my rules. Right now > they've decided to refernish the division I personally would first paint > the walls, then do the carpeting, then bring the new furniture. They are > doing this in exactly the opposite order, some of the new furniture is > already here, and painting doesn't start till monday, and we'll still > have to wear corparate attire. And we can't really argue.. :) > > >> Oleg, >> >> If you want to be a spreadsheet developer and not a database >> developer, then continue with your spreadsheet thinking. But if you >> do want to be a database developer, please follow Francisco's advice. >> >> Charles Wortz >> Software Development Division >> Texas Education Agency >> 1701 N. Congress Ave >> Austin, TX 78701-1494 >> 512-463-9493 >> CWortz at tea.state.tx.us >> (SELECT * FROM users WHERE clue > 0) >> >> >> -----Original Message----- >> From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] >> Sent: Thursday 2003 Feb 06 13:11 >> To: accessd at databaseadvisors.com >> Subject: Re: [AccessD] Maximum number of columns in a table ? >> Importance: Low >> >> >> Francisco, >> >> right now we have column fields 2m(onths) 3, 4-6, 7-12, >2y (years >> which is 13 - 24) and <2y (goes up to 30 years)) Now they want a field > >> for each individual monts; I think that creating a table with roughtly > >> 70 fields would be the most painless solution (and from it a query >> with original fields - 4-6, 7-12, and reling it as datasource for >> reports) >> >>> Oleg, >>> 70 fields? I recommend reviewing the benefits of normalization, >>> specifically BCNF which is a derived from 3NF >>> http://databasejournal.com/sqletc/article.php/1443021 >>> >>> more hits on google: >>> http://tinyurl.com/5g4v >>> >>> -Francisco >>> http://rcm.netfirms.com >>> ----- Original Message ----- >>> From: "Drew Wutka" <DWUTKA at marlow.com> >>> To: <accessd at databaseadvisors.com> >>> Sent: Wednesday, February 05, 2003 3:47 PM >>> Subject: RE: [AccessD] Maximum number of columns in a table ? >>> >>> >>> : I believe the number of fields in a table is 255....I am assuming >>> it's the : same for a query. >>> : >>> : Drew >>> : >>> : -----Original Message----- >>> : From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] >>> : Sent: Wednesday, February 05, 2003 1:44 PM >>> : To: accessd at databaseadvisors.com >>> : Subject: [AccessD] Maximum number of columns in a table ? >>> : >>> : >>> : I need to feet around 70, can I ? I found this on google, but >>> somehowi >>> : don't trust it; o limit on rows ?? >>> : ------------------------------------ >>> : >>> : Maximum number of rows per table No Limit >>> : >>> : Maximum number of tables per database No limit >>> : >>> : Maximum number of tablespaces per database 32767 >>> : >>> : Maximum number of devices 32767 >>> : >>> : Maximum storage capacity 70 TB >>> : >>> : Maximum row size (excluding BLOB & FO columns) 3992 bytes >>> : >>> : Maximum number of columns per table 252 >>> : >>> : Maximum number of columns per index 16 >>> : >>> : Maximum number of journal files per database 8 >>> : >>> : Maximum length of table/column name 18 bytes >>> : >>> : Maximum number of tables per join 31 >>> : >>> : Maximum number of savepoints per transaction 32 >>> : >>> : Maximum cache memory 2GB > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com ----------------------------------------- Send a Xuppa Valentine to Your Sweetheart today! http://www.xuppa.com/greet/