SQL Server Performance

Search Results

Search Again
  1. ms_crb

    _DBREINDEX and MDF file size

    Post by: ms_crb, Oct 26, 2005 in forum: Performance Tuning for DBAs
    I put the DBCC DBREINDEX @tablename into a cursor and executed each statement separated, that worked great on the development server. I will be...
  2. ms_crb

    _DBREINDEX and MDF file size

    Post by: ms_crb, Oct 21, 2005 in forum: Performance Tuning for DBAs
    I was able to reindex two of my larger tables using dbcc reindex tablename, this weekend I will run the dbcc reindex table in batches to test to see...
  3. ms_crb

    _DBREINDEX and MDF file size

    Post by: ms_crb, Oct 20, 2005 in forum: Performance Tuning for DBAs
    I am using the sp _dbreindex and reindexing the whole database. Since I kept running out of space I thought shrinking the database first might help...
  4. ms_crb

    _DBREINDEX and MDF file size

    Post by: ms_crb, Oct 20, 2005 in forum: Performance Tuning for DBAs
    autogrow is checked, filegrowth in megabytes 1, maximum file size- restrict file growth to 42000 mb. ------------ Originally posted by LuisMartin...
  5. ms_crb

    _DBREINDEX and MDF file size

    Thread by: ms_crb, Oct 19, 2005, 18 replies, in forum: Performance Tuning for DBAs
    I am running a _dbreindex database job in production that keeps failing with the following error. Could not allocate space for object in database '*'...
Showing results 1 to 5 of 5
Search Again