Solved SQL Server for Moving from Access Backend to SQL Server (1 Viewer)

Galaxiom

Super Moderator
Staff member
Local time
, 08:34
Joined
Jan 20, 2009
Messages
12,227
- But if you use pass through queries with T-SQL,
Pass through queries are not a panacea either. The ODBC interface passes any query it can back to the server. If the query is not too complex, and especially if it doesn't have user defined functions in Access the use of Pass through often makes no significant difference to speed.
Optimize, optimize optimize.
Issac has understated the importance of this here. ;)
 

Users who are viewing this thread

Top Bottom