Re: Query performance MS-Access vs. SQL-server 2000

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 01/12/05 

Date: 12 Jan 2005 06:17:16 -0800

Just a general observation as I know relatively little about Access: If
you only want to use SQL Server in the same way as you use Access then
don't bother. You are probably better off with Access.

On the other hand, if you want to write scalable, performant SQL Server
applications then use TSQL stored procedures as your data access layer
and avoid dynamic SQL code. Don't expect to flick a switch to make the
change and don't be deluded by the "upsizing wizard". Moving to SQL
will probably require re-architecting and rewriting substantial
portions of your application. The kind of performance comparison you
are attempting therefore isn't very meaningful or useful IMO. 

--
David Portas
SQL Server MVP
--
Loading