Dina, thank you for information and yes if could help me out I will help me a lot. I am not at all good i SSIS and SSRS.

🙂

Yes that is right.

I have script to display index stats , My report should have parameter which will list all the servers I have and then depending on the server...

Thank you all for the response. This has really helped me.

There are two process one running update another running insert statement accessing same table primary key.

I have added the missing indexes from the update code. But still not helpfull .

ON tb_Import_Data

for fields ([comp_name],[import_record_id])

INCLUDE ([comp_id])

Still I recive the same deadlock

If you are planning for 2 node failover cluster..then few things to consider

1) Storage and how are you planing to store data , log , backup temp files

2) IP address,...

That is for SQL Server 2005, also I need the best practice to optimize the disk storage

My DB grows 30 - 50 GB in a day and yes we...

Thanks Jones.

Let me do the small testing and check.

I really appreciate your time and sorry I did not explained much on this we have content management App and the table systempagecache have the pagename information. We want...

Thanks Whittle. Always helped on time.

let me note own this way

SQL server instances : 2 virtual names

MSDTC : one

Windows clustering : one

Thank you all.

Thanks Perry manually creating the computer objects in AD for MSDTC and restarting the service had helped me, but Iam once again receiving the same type of error for SQL...

Hi Lynne,

Any update, did it solve the issue?

As this is a 32 bit env, 2 GB will be vailable for the application. hence the instances which started first will take most of memory then the 2nd....

SQL Server 2008 version information

The following table lists the major releases of SQL Server 2008. Collapse this tableExpand this tableRelease Product version

SQL Server 2008 Service Pack 2 10.00.4000.00

Build...