Can someone tell me what advantages I would be looking at for using MS SQL as my backend for database. We're seeing higher and higher performance losses on slow queries etc. I don't know much about SQL so any help would be appreciated.I'm not an expert on Access, so here are some points for SQL Server, not all but a start:[list=1]
Can handle more concurrent users
Better handling of locks and lock types (nolock)
Stored procedures
Cached queries
Cached data
Much more flexible with backup and recovery, up to the minute
Triggers to implement business rules
[/list=1]|||Take a look at the following link:
click here (http://http://www.swynk.com/friends/Vartanyan/Access_vs_SQLServer.asp)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment