SQL Server Performance

Search Results

Search Again
  1. reddy71752

    How to determine when index statistics need updating?

    Post by: reddy71752, Dec 2, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs
    You can run sp_updatestats against the database, it will update the statistics on those tables which were modified recently. Thanks, Reddy
  2. reddy71752

    Backup and Disaster Recovery Procedures

    Thread by: reddy71752, Dec 1, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions
    Hi Friends, I need to write a script to check the following things 1. Type of backups using for all databases 2. Need to check whether system...
  3. reddy71752

    Backup and Disaster Recovery Procedures

    Thread by: reddy71752, Dec 1, 2008, 0 replies, in forum: SQL Server 2005 General Developer Questions
    Hi Friends, I need to write a script to check the following things 1. Type of backups using for all databases 2. Need to check whether system...
  4. reddy71752

    How to update statistics on all the databases views

    Thread by: reddy71752, Nov 6, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions
    Hi Folks, I want to update statistics on all database views in a server, by using sp_updatestats i can update statistics on all database tables only...
Showing results 1 to 4 of 4
Search Again