Sql - Estimated Cost For The SP?

Jan 24, 2011

In my asp.net application, I want to show the user that when he is submitting the form how much time does that stored procedure is going to take. Is there any way I can find out from asp.net application? Just like we have estimated query plan with estimated cost in sql server. Can we show it on asp.net webpage?

View 2 Replies


Similar Messages:

ADO.NET :: How To Find The Sum Of The Cost

Nov 25, 2010

I need to find the Sum of the Cost ,I tried doing it , but i am not aware of the syntax.

var pss = new PrintingServiceDataContext();
var strActualvalue = pss.PrintJobs.Where(s => s.OwnerID == txtOwnerID.Text && s.CreatedOn >= firstDay && s.CreatedOn <= today).Select(s => Sum(new {PCost = s.Cost }));

View 4 Replies

Create A New Web-site With No Cost?

Feb 14, 2011

One of my relatives is going to start a small salon. I would like to develop a small web-site (that is pretty basic: display information, book an appointment, display product/service information, show directions to the salon, etc). I can use a XML file as a basic data storage and am not intended to use any database for this. I can deal with the coding development of the web site, but I have not developed any web-site independently and have no detailed knowledge about how to host the site, etc. factors. I also would like to know that whether it's possible to develope such a web site using ASP.BET (Visual Web Developer) with NO cost?

View 8 Replies

C# - Performance Cost Of A Try/catch Block?

Aug 13, 2010

Possible Duplicate:
Performance Cost Of ‘try’

I am being told that adding a try catch block adds major performance cost in the order of 1000 times slower than without, in the example of a for loop of a million. Is this true?

Isn't it best to use try catch block as much as possible?

View 7 Replies

DataSource Controls :: Clustered Index Seek Cost 100%?

Apr 13, 2010

I have a user defined function GetAddress which takes address id (int) as a parameter and returns a address which may contain some 200 to 300 characters...In the execution plan for that function it is displaying cluster index seek cost as 100%...I have clustered index for address id in the address table..is that costing the resources more...How to decrease the cost of the function or a query...!!

View 1 Replies

Project Cost And Duration Estimation And Hourly Rate For Freelance Project?

Oct 1, 2010

Approximate cost of the project Duration of the project ( There are 2 Developers ) Can I charge the client for software license ( like Visual Studio license since I have purchased it by paying a hefty amount)

My profile as a developer is as follows:

I am a C#, .net, ASP.net developer with 3 years experience in enterprise class web and desktop projects. I can work 20 hours a week

The brief requirements of the project are as follows::

I have to develop an Ecommerce website. The website is meant for buyers, sellers, advertisers and bidders ( I would say it is Business to Business and also Business to Customer site ) The HTML's will be given by the client. The website will have all the features of any Ecommerce site like buying products, selling them, searching products, sorting them,etc The website should conform to W3C standards

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved