You are here: Re: Access and SQL Server Speed Comparison « MsSQL Server « IT news, forums, messages
Re: Access and SQL Server Speed Comparison

Posted by Russ Rose on 03/02/07 03:24

"SQL Learner" <excelmodeling@gmail.com> wrote in message
news:1172791357.025040.97000@s48g2000cws.googlegroups.com...
> Hi,
>
> I have a table with 8 millions records. Some of the fields needed to
> be parse and modified. Example, "ABC DEF" will be parsed into two
> fields "ABC" and "DEF". And If there is "123" in the field, if will
> be replaced by "456". For example, "XYZ 123 AAA" will be "XYZ 456
> AAA". Also, update query and append query will be used in the
> project.
>
> Give the above information, what will be a faster database to do this
> - MS-Access 2003 or SQL Server 2000?
>
On equal hardware SQL Server 2000 will run the query faster. Depending on
your skills it may take longer to write the queries on SQL Server 2000 than
it takes to write and run in Access...

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация