Tuesday, February 14, 2012
Design Choices
I have 20-30 action queries which will be executed nightly. Is it better to place them in a DTS package and call the package, or place them in a stored procedure and call the stored procedure?If you are using a Access dtabase on a web site and using an inc file for your data connections I can down load the database and crack security. As for the performance of Acess it sucks over 1,000,000,000 records.|||This is for a SQL Server database. I'm not looking for your opinion on Access|||depends on what your action queries do. If you need to move data then DTS is the way to go. If you need to work with data inside SQL server then I would faver stored procedures.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment