Parameter Sniffing and SQL Server

        Today I came to know about an interesting point “Parameter Sniffing”. I search on net and found some good material and facts about it. First, what is parameter sniffing? Below is the definition which I got from here.
“Parameter sniffing refers to a process whereby SQL Server’s execution environment “sniffs” the current parameter values during [...]

Read Full Post »

HTTP could not register URL http://+:8000/. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details)

        You may find this error when you try to register WCF service host using HTTP binding in windows vista. I had the same problem and I found the perfect solution here.

Read Full Post »

Value does not fall within the expected range exception while using ReportDataSource

           Here is my code which produce “Value does not fall within the expected range” exception. 
 ReportDataSource objReportDataSource 
              = new ReportDataSource(“CategoryProduct”);
 objReportDataSource.Name = “NewDataSet_CategoryProducts”;
 // dsDataSet is DataSet object
 objReportDataSource.Value = dsData;
            After doing some try and error method I found that this exception is due to objReportDataSource.Value = dsData. You need to assign a DataTable to Value property instead of [...]

Read Full Post »