Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    173

    Unanswered: access to sql upgrade

    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.

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    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]
    MCDBA

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    Take a look at the following link:

    click here

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •