I have a situation where i need to optimize the query to perform better. possibly a solution. Here is the situation. I have a table with the following fields(I am putting only those are significant to the scenirio) WorkItems[Table] StartDate EndDate Stage CompletedDate I need to calculate a value named status according to various conditions involving the above parameters. Like If StartDate < getdate() Status = Green etc.. I created a function called CalculateStatus Passing all the above parameters and added one computed colum in the WorkItems table to call this function. Since column is non deterministic i cant add a index to this column. Now when i blindly do a select of status the same is getting calculated very fast The issue is when i use this computed column with aggragate function like 1) SELECT count(Status) FROM WorkItems Or when doing a group by 2) SELECT Count(WorkItemId),Status FROM WorkITems Group BY Status Could you please guid me how i could optimize the situation so that i can make things faster. Thanks in advance for your valuable time Sreehari ARanghat

Thanks Laddie Kindly rate if the answer was helpful

Hi Guys, Any recomendations on hosting provides providing RDP access ?.. Thank you Laddie

Thanks Laddie Kindly rate if the answer was helpful

Query Strings in ASP.NET[^]

Thanks Laddie Kindly rate if the answer was helpful

Reading and Writing Excel using C#[^]

Thanks Laddie Kindly rate if the answer was helpful

Hope this helps. Compress and Decompress files using C#[^]

Thanks Laddie Kindly rate if the answer was helpful

Thank you pete.

Thanks Laddie Kindly rate if the answer was helpful

Hi Guys, Any one has idea on how to host a workflow designer inside a ASP.NEt page. Thanks in advance for your suggestions Sree

Thanks Laddie Kindly rate if the answer was helpful

Hi Chris, Sure it could be a malicious code for the providers. But the requirement in my hand is to track where on the mail did the user clicked and to award somepoints to him. Any suggestion how we could do this without hurting or troubling neither the user nor the mail providers ? Thank you

Thanks Laddie Kindly rate if the answer was helpful

Hi Guys, I have a small requirement where by i need to find out where in a mail did the user clicked. I am adding some small javascript to find out the same and send the result back over a XMLHttp request. Things works fine with the rendered HTMl in browser however if i send this content to a mail address it looks like the providers take out the scripts. Thus the javascript does's't fire. Could you advice me if there is a woraround for this. Thank you

Thanks Laddie Kindly rate if the answer was helpful

Hi Paul, Thanks for the reply. I am looking for the security design pattern reference from a application perspective. Something that will answer the questions like. What are the general security cheklists of a web app? How to module the client and server side validations? What are the Common security loop holes? Security Test cases for general Webapp? etc..

Thanks Laddie Kindly rate if the answer was helpful

Hi guys, Do you have any good references on website security models and arch?. Not with any specific technology but on a high level design perspective.

Thanks Laddie Kindly rate if the answer was helpful

Hi Guys, When i tried to compile my ASP.net application i got the followig error. "ASP.NET runtime error: Error HRESULT E_FAIL has been returned from a call to a COM component." Any idea what is it trying to tell me ? Thank you

Thanks Laddie Kindly rate if the answer was helpful

Hi Guys, I have a doubt on Master page content page merging. 1) Which life cycle of the http request does this happens ? 2) Logically the pageload of the master page has to execute before the content page. How ever it looks vice versa. Which is the correct way? Thank you for your support Sree

Thanks Laddie Kindly rate if the answer was helpful

Hi, Just wondering how does IIS identify the client and map to a specific session. I mean when we open a web application in two different browsers the IIS openes two different sessions how does IIS know to map requuests comming from this two browsers to respective Sessions. I was thinking there may be some king of cookie stored in the client to hold a token or something but what if the client does not allow cookie ? Thanks in advance for your help

Thanks Laddie Kindly rate if the answer was helpful

Hi Guys, I have a doubt on how security is implemented when calling a webservice using javascript. My concern is that when the application is running in http any one can easily know which javascript function is called and which webservice function it is calling and the location of the service also. In this case how do you know if it comming from the right source or not ?. What are the ways security can be implemented in thie scenirio? Thank in advance for your advice.

Thanks Laddie Kindly rate if the answer was helpful

Better to say not as easy as launching a software.

Thanks Laddie Kindly rate if the answer was helpful

And considering the fuel price hike. I fear they may cut short packages to certain destination than offering packages to other planets.:-)

Thanks Laddie Kindly rate if the answer was helpful

Add the id in to the datakey names then you can get this id while pressing the delete by gridView1.DataKeys[e.SelectedIndex].Values[0].ToString();

Thanks Laddie Kindly rate if the answer was helpful

Go to Visual Studio > Help > About Visual Studio

Thanks Laddie Kindly rate if the answer was helpful

Setp 1 : Go to your web application(VD) right click > properties find out the application pool name to which it is added. Step : Now go to that applicatio pool right click > properties > Recycling tab There are many versions to configure the recycling by minutes/per requests/Byy schedule etc. You can reconfigure this with your values and save it. (Note this will work only if you are using IIS 6)

Thanks Laddie Kindly rate if the answer was helpful