SQL Server Performance

Looking for general guidelines

Discussion in 'General Developer Questions' started by mrwizard10, Aug 14, 2003.

  1. mrwizard10 New Member

    We are migrating a ColdFusion based thin client application with a MSSQL 7.0 backend to MSSQL 2000. Our app/dev team is looking for any assistance/general guidelines/tips/ gotchas that others might have encountered when doing this. They are especially interested in what effects might be encountered with developed stored procedures and SQL Agent processes.


  2. gaurav_bindlish New Member

  3. vbkenya New Member

    If your intention is just to reuse the SQL Server 7 stored procedures in your new SQL server 2000 implementation then you shouldn't be very worried. All your code should be compatible.

    Performance enhancements are another issue all together and you may want to think about other database objects and their design as well.

    Nathan H.O.
  4. Argyle New Member

    Watch out for collation conflicts if the SQL Server 2000 system databases have a different collation/sortorder than your SQL 7 database that you are migrating. If tempDB has a different collation that your user database you can run into problems.

  5. Twan New Member

    The use of table variables instead of temporary tables can give performance benefits

Share This Page