Solved

Fill Factor & New Index for my Table

Posted on 2006-06-26
3
362 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
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
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

752 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