Wednesday, February 29, 2012

Bad Request Error 400 - WCF Client

I have encountered the Bad Request Error  400  in WCF client and  i have analyzed this issue and found that main cause of this error is the BIG SIZE of request and it exceeded the default wcf request max limit .
To resolve this issue , you have to make following changes in WCF config file (in both config file client and server )  and increase  MaxBufferPoolSize, MaxReceivedMessageSize to allow huge contents

    <binding maxBufferSize="64000000" maxReceivedMessageSize="64000000" maxBufferPoolSize="64000000"

      <readerQuotas maxDepth="64000000" maxStringContentLength="64000000" maxArrayLength="64000000" maxBytesPerRead="64000000" />

      <security mode="None"/>


Note : we can increase the maximum request size to 50MB  for ASP.NET Runtime (IIS)

> Thanks for visiting !!

SQL Server - Identify unused indexes

 In this blog, we learn about the index usage information (SYS.DM_DB_INDEX_USAGE_STATS) and analyze the index usage data (USER_SEEKS, USER_S...