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.

    Thanks

    Bob
    mrwizard10, Aug 14, 2003
    #2

  2. gaurav_bindlish New Member

    gaurav_bindlish, Aug 14, 2003
    #2

  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.
    Moderator
    SQL-Server-Performance.com
    vbkenya, Aug 14, 2003
    #2

  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.

    /ARgyle
    Argyle, Aug 14, 2003
    #2

  5. Twan New Member

    The use of table variables instead of temporary tables can give performance benefits
    Twan, Aug 14, 2003
    #2

Share This Page