Solved

Fill Factor & New Index for my Table

Posted on 2006-06-26
3
358 Views
Last Modified: 2006-11-18
I have a table ST020100 in my database there are two index on my Database
1. Primary Key
2. Non Clustered Index (Composite)

This database has huge Insertion of records and selection of data is only once in Midnight. Fill Factor in our database for both this indexes is 80%.

We are running a Trigger on Insert, which inserts record into another table after joining two more tables. Some times this trigger of ours fail.

Can you help me what exactly has to be done on this?



0
Comment
Question by:dduser
3 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16982932
>which inserts record into another table after joining two more tables
we would need to have information about all the indexes for all the tables involved, and of course the trigger code here to give suggestions.
also, what is the error code?
0
 
LVL 28

Accepted Solution

by:
imran_fast earned 500 total points
ID: 16983737
AngleIII
this is the thread he is talking about
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21898840.html


Already mentioned in the above thread Create Indexes on the tables to speed up the select query
and increase the size of mdf.

Why increase size of mdf?

You mentioned that you are copying huge amount of data from two tables then every time sql server run out of space for the database it allocates new space for that database which is time consuming so you should have extra space in the mdf.

Also you should leave some extra empty space in the ldf (log file for you database). specially if your recovery mode is not simple. and take regular backup for these logs.
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 16988138
>> 1. Primary Key
2. Non Clustered Index (Composite) <<

Specifically what columns is each index on?  
Are the values in those columns always ascending or are they random?  
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question