Re: reindex or update stat

From: Jen (anonymous_at_discussions.microsoft.com)
Date: 02/19/04 

Date: Wed, 18 Feb 2004 16:26:05 -0800

Thanks. In the past we did experience some problem in that few days. actually it's about 60,000 in one table, and every record in this table will be doubled in another table, that is 120,000. How much will be the red line?
     
     ----- Andrew J. Kelly wrote: -----
     
     Jen,
     
     20,000 rows is really not all that many and will most likely not cause a
     change in the way the queries are run. It's possible but not enough to get
     excited about. The once a week will most likely be fine.
     
     --
     
     Andrew J. Kelly
     SQL Server MVP
     
     
     "Jen" <anonymous@discussions.microsoft.com> wrote in message
     news:1FB99858-33E7-43A8-A561-51BD048C53F6@microsoft.com...
> Hi,
> I have a database that will have couple thousands row inserted normally,
     but there will be 3 or 4 days in a year that will have 20000 row inserted
     daily. I set up the Maintenance Plan to have Optimizations to reorganize the
     data and index, and it runs once a week. During that busy week how can I
     imporve the performance? Thanks
     
     
     

Relevant Pages

  • Re: Recovering SQL Server 2000 database without a backup
    ... >>Andrew J. Kelly ... >>SQL Server MVP ... >>> database and I don't have a recent backup. ...
    (microsoft.public.sqlserver.tools)
  • Re: Restricting Users View in Enterprise Manager
    ... Andrew J. Kelly ... SQL Server MVP ... "Julian" wrote in message ... I want> to restrict the view for this user so that they can only> see their own database in Enterprise Manager. ...
    (microsoft.public.sqlserver.security)
  • Re: Databaseaccess
    ... If that database is on the same server then just make sure the user from the ... >>You limit access by assigning rights to Logins. ... >>Andrew J. Kelly ... >>SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Creating documentation
    ... Is there a way to print a list of tables, queries, etc. ... for use in documenting a database created by another ... etc. that exist in this legacy database. ... Andrew ...
    (microsoft.public.access.reports)
  • Re: interesting problem
    ... It's useful to keep a table of Numbers in your database to help with queries ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)