Saturday, February 20, 2010

Host Name Issue With WCF

Hi, Eairlier i faced one issue in WCF that i was not able to generate the proxy class on client machine after deployment of WCF on remoting machine. i spent almost two hours to find out the root cost of this issue then i found that it was due to the URL of location in WSDL file and URL was having the fully computer name of server and In outer words, this Host name is not mapped with any external IP address So i was not able to genetrate the proxy class on the clinet machine.

i googled and found one solution we have to change the IIS hosting binding setting but it was not fesible with production.

I fixed this issue with very smart way.

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...