You can improve the quality of SellerDeck Enterprise SQL’s general performance by performing the following maintenance:
Rebuilding an index drops and re-creates the index. This removes fragmentation, reclaims disk space by compacting the pages based on the existing fill factor setting, and reorders the index rows in contiguous pages:
Please see steps below, and perform with care:
1. Open 'Microsoft SQL server management studio'
2. First, ensure you make a backup of your SQL database.
3. Then go to 'View | Object Explorer'
4. Connect to your SQL Server Database Engine and then click + to expand the properties of the SQL server.
5. Expand 'Databases', then expand the database for the site you are using
6. Expand 'Tables'. You will now see a long list of tables. Expand the first table in the list which has a prefix 'dbo.', for example 'dbo.Additional Files'
7. Right-click 'Indexes' and then click 'Rebuild All'.
8. To start the rebuild operation, click 'OK'
9. Repeat this process for all tables which contain an 'Indexes' folder.
Source:
http://technet.microsoft.com/en-us/l.../ms187874.aspx
Rebuilding an index drops and re-creates the index. This removes fragmentation, reclaims disk space by compacting the pages based on the existing fill factor setting, and reorders the index rows in contiguous pages:
Please see steps below, and perform with care:
1. Open 'Microsoft SQL server management studio'
2. First, ensure you make a backup of your SQL database.
3. Then go to 'View | Object Explorer'
4. Connect to your SQL Server Database Engine and then click + to expand the properties of the SQL server.
5. Expand 'Databases', then expand the database for the site you are using
6. Expand 'Tables'. You will now see a long list of tables. Expand the first table in the list which has a prefix 'dbo.', for example 'dbo.Additional Files'
7. Right-click 'Indexes' and then click 'Rebuild All'.
8. To start the rebuild operation, click 'OK'
9. Repeat this process for all tables which contain an 'Indexes' folder.
Source:
http://technet.microsoft.com/en-us/l.../ms187874.aspx