Post reply

system tables in sql 2005

  • May 21, 2010 at 3:08 am

    #140471

    Please let me Know how to list the common systemtables in each user databases in sql 2005

    Apart from system tables i need to tune all the tables in user database

    & Please provide the methods to tune the User databases

    i need to do this task in one of our production sql2005 server

    Thanks in advance

  • May 21, 2010 at 6:22 am

    #1170764

    select * from sys.all_objects where type_desc = 'SYSTEM_TABLE' --all sys tables

    select * from sys.all_objects where type_desc = 'USER_TABLE' and is_ms_shipped = 0 --all user tables

    aside from that, you do not tune tables, you tune queries, so you need to identify underperforming queries to do any tuning.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 21, 2010 at 8:09 am

    #1170852

    You can defragment (rebuild or reorg) the indexes on tables for better performance.

    There are lots of posts and articles about this topic you can search for.

  • May 21, 2010 at 5:28 pm

    #1171146

    Also, make sure that you update databases statistics regularly.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply