use Non-Queried default values with following values for Start and End dates respectively.

=DateAdd("d", -90, Today)

=DateAdd("d",...

Thanks for your response guys, but i have resolved the issue. There was a missing INCLUDED column in an index (how stupid i am).

Thanks GSquared you da man.

I checked the plan previously and i thought it is fine....but now i looked it more closely and figured out a missing INCLUDED column in...

GSquared (8/18/2009)

---

For that kind of situation, your best bet is usually to insert the data into a table that has a session ID in it, and the row numbers, and...

GSquared (8/18/2009)

---

Will this do what you need:

select top 25 * , ROW_NUMBER() over(ORDER BY lead_stage DESC , Lead_LeadId DESC ) AS rowranking

from vListLead

WHERE Lead_AssignedUserId=523 AND lead_status = N'In...

Unfortunately, but yes same issue with BETWEEN.

No, because "WHERE rowranking > 0 and rowranking < 26" is used to implement the paging on the web page, each page displays 26 items at a time.

didn't find anything memory intensive, everything looks normal on that side.

Now on the web page side we are getting "Data provider or other service returned an E_FAIL status" error due...

Thanks for replying Yelena, i have already checked that and its not caused by any other job or antivirus atleast.

Thanks guys, will do these tests and provide you feedback.

Windows server 2003 Enterprise sp2, and .net 2.0

btw my colleague is able to deploy the same code, we both have the sysadmin rights on sql server, but i am getting...

Using the deploy option in visual studio, selected the required sql server 2005 database connection and 'Unsafe' permission level.

I have the sysmtem.dll in the reference also I have included the...

I have the required reference and project is building successfully, but i am getting this error while deploying it to the database.

FYI i have restore the databse from one server...

Sorry Greg i should have provided the update on the actuall post too:-).

But yes problem fixed - by mistake i was using restore LOG instead of restore DATABASE for...

Lynn Pettis (6/9/2009)[hrThis is where I would say a mirrored db with a secondary (1 or more) log shipped db with an interval of 5 to 15 minutes. Not...