One Question !

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Noor (noor_at_ngsol.com)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 07:49:40 -0700

I have a database that is heavily indexed and that the users query
extensively. The database has grown and query response time has slowed. The
database is stored in a single data file. I want to accelerate query
response time. What should I do?

On a new hard disk, should I create a new filegroup. Drop the existing
nonclustered indexes, and then re-create them on the new filegroup

OR

On a new hard disk, add a new file to the PRIMARY filegroup. Drop the
existing nonclustered indexes, and then re-create them on the PRIMARY
filegroup

Thanks
Noor

Relevant Pages

  • Re: Issue with a table that is 75%-80% of the database size
    ... SQL Server 2000 does not support table partitioning. ... Have you tried database differential backup? ... your query response time and backup time. ...
    (microsoft.public.sqlserver.server)
  • Form refresh when activating a ADOQuery
    ... I am activating an ADOQuery against a very large database. ... The response time for the query sometimes takes as long as 20 minutes. ...
    (borland.public.delphi.database.ado)
  • Issue with a table that is 75%-80% of the database size
    ... Our database easily grows to a size over 250 GB and up. ... Users connect to the database through a Query application ... The concerns are to improve the response time for each ... How about partitioning a particulare table? ...
    (microsoft.public.sqlserver.server)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)