Depending on the data value for these queries, I would say that the calls to the UDFs are a part of the problem. As you have nested calls withing...

As long as we aren't doing your work for you, not a problem to come and ask questions and get help where yo are struggling. The key is you...

I assume that this function, dbo.fn_GetCutoverTime, makes a call to a database table for information?

Really need more information to help you. If you would read the second article I reference in my signature block it will tell you what information we need and...

Can't answer your first question, but the answer to your second is probably. Iknow it is necessary when changing versions (2005 -> 2008 for instance). Not too sure...

You probably haven't gotten an answer as no one has an answer. I am not a SSRS person, so I know I don't have one for this problem.

Duplicate post, please post any responses here[/b].

Okay, Shot in the dark here, could be a permissions issue. Since we can't see from here what you see there, not much else we can do.

Partitioning in this case may not buy you anything. You say you have tuned the query, what does the indexing look like on the table(s)?

In SSMS, in the actual execution plan right click and save as a .sqlplan. Attach that to your post on this thread.

Here are two options depending on how you send the date to the query:

DECLARE @SelectYear DATETIME;

SET @SelectYear = '2012-02-01'; -- With this date, select all records in 2012

SELECT

...

Mathew M.Varghese (6/4/2012)

---

Dear Daxesh Patel,

You are correct. If i run "update statistics table " and check DBCC SHOW_STATISTICS, Row sampled is only 20% of actual rows.

If database "auto update...

Sorry, but from your original post, I really have no idea what you...

I have to agree with the above post. If your response times are good after a rebuild of the indexes and then falls off when you do an UPDATE...

Show us what you have done so far to solve your problem. What problems are you having getting the solution you ar trying to develop?