We use no fill factor hint when we build indexes.

Thanks Sir for your valuable time. We are using default values that you have asked. The attached image file will explain more. We are using two mdf, ldf files for...

Thanks for your valuable time.

We are currently using all default values in "Advance TAB" and no query hint for paralalism is being used. We have currently have both short...

Thanks Gail for your valuable time,

We are using mix type of transaction both short and long procedures for reports. We don't have separate Server for Reporting right now. Should We...

Both application and DB Server are dedicated at different machines. Both are in same Rack connected through LAN at same domain.

Thanks

Azhar

Now, I am running MS SQL Server 2008 R2 on window Server 2003 Enterprise R 2 64 bit.

Total RAM= 8GB

MS SQL Server RAM=6.4 GB

Total Hard Disk=408 GB

When I execute...

For Further detail, Pl find attached txt file which contains tables, procedure and function definition respectivly. Execution Plan is also attached.

Row counts of tables is as given

1:- Cr_Co_Loanee 536103...

Pl find ziped attached files of Actual execution plan xml file,CPU time file and Schema file of two main tables. I have created some indexes as well given below

CREATE INDEX...

HopeFully this picture will explain things more.

Thanks Dear.