SQL Server 2000 Optimization Tips

Posted on August 20, 2008 | Leave a comment

  • For the very large databases, use distributed partitioned views to partition tables horizontally across multiple servers.
    This is a new SQL Server 2000 feature, which is available when using SQL Server 2000 Enterprise Edition only. Due to distributed partitioned views, SQL Server 2000 now on the first place in the TPC-C tests.

    • *****

  • Use indexed views to increase the speed of your queries.
    The result set of the indexed view is persist in the database and indexed for fast access. Because indexed views depend on base tables, you should create indexed views with SCHEMABINDING option to prevent the table or column modification that would invalidate the view. Furthermore, using views instead of heavy-duty queries can reduce network traffic and can be used to facilitate permission management.

    • *****
    Read more on MSSQLCity.com

    Advertisements
    This entry was posted in Administration, SQL. Bookmark the permalink.

    Leave a Reply

    Fill in your details below or click an icon to log in:

    Gravatar
    WordPress.com Logo

    You are commenting using your WordPress.com account. ( Log Out /  Change )

    Google+ photo

    You are commenting using your Google+ account. ( Log Out /  Change )

    Twitter picture

    You are commenting using your Twitter account. ( Log Out /  Change )

    Facebook photo

    You are commenting using your Facebook account. ( Log Out /  Change )

    w
    Cancel

    Connecting to %s