Networks

Ask something
Question Locked

Question on Slow Speed on Access to run SQL

0 helpful
2 replies

by hunterzh

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I've designed an Access project, by Access + SQL Server 2000. In the project, I've written several stored procedures. But one problem is: when I try to run the stored procedure in Query Analyzer, the speed is quite fast; while when trying to run the SQL query in Access, the speed is very slow. What might be the reason? How can I increase the speed of SQL in Access project?

2 replies

by a23ea

http://groups.google.com/group/microsoft.public.sqlserver.programming/msg/ff9e6e72122e1fb?q=parameter+sniffing+author:Bart+author:Duncan&hl=en&lr=&ie=UTF-8&oe=UTF-8&rnum=1

This discussion is closed to new replies.