Ok. I misunderstood your problem. You don't have to sign the serialization assembly. How are you signing your original assembly? Validate that:

1) In the project where...

Create a keyfile and then use the Assembly linker to sign the assembly with the key file.

http://msdn.microsoft.com/en-us/library/xwb8f617.aspx

Remoting is not supported or allowed under SQLCLR. It uses connections that can not be done inside the hosted environment.

I'd test that with SQLIO before implementing it in production use. A 8 disk RAID 10...

aparna.athmanathan (6/2/2009)

---

Important Note:Since SQLCLR does not understand the config files,I have written everything in c# like opentimeout,readerquotas both in service end and also in sql server project which is consuming...

You are already changing the architecture based on the original design you mention in your first post. I don't understand what would make doing it the correct way, any...

Why are you trying to do this through SQL Server? Why don't you let your application talk to the WCF Service directly to get the report? Calling WCF...

Not to my best...

+1 Erland has covered this topic better than anyone else.

Use the sys.dm_db_index_physical stats DMF to get the fragmentation information:

http://msdn.microsoft.com/en-us/library/ms188917.aspx

What do the index fragmentation and density levels look like between the two partitions? What differences are there in execution plans, and what if any differences exist for the...

The reference for Lock Pages in Standard Edition is:

http://blogs.msdn.com/psssql/archive/2009/05/19/an-update-for-standard-sku-support-for-locked-pages.aspx

You have to apply CU4 to SP3 for Standard Edition, but even then, I don't think your expectations match what Lock Pages in Memory will do. What exactly are...

Mike Gray (6/1/2009)

---

nothing much in the error logs and the tempdb is not set to Auto Shrink. It looks like I just need to run a shrink against it. Should...

Rebuilding an index does a fullscan update of the statistics. Unless you specify the WITH FULLSCAN option of UPDATE STATISTICS, you get a sampled update which may or may...