Thanks!! Something else was causing this issue which is now resolved.

Phil Parkin (2/15/2013)

---

Sachin Vaidya (2/14/2013)

---

Hi Cadavre,

Your response definitely shows a path to move ahead, thanks a lot for that.

But on the other side, it was very rude. It will discourage...

ChrisM@Work (2/15/2013)

---

Sachin Vaidya (2/14/2013)

---

Hi Cadavre,

Your response definitely shows a path to move ahead, thanks a lot for that.

But on the other side, it was very rude. It will discourage people...

Hi All,

For the sake of all visitors to this post, here is the solution that I figured out, with combination of my own effort, plus some other online help.

Thanks.

;WITH CTE1...

Hi Cadavre,

Your response definitely shows a path to move ahead, thanks a lot for that.

But on the other side, it was very rude. It will discourage people from putting any...

Hi,

I figured out my mistake. I have declared the data type as varchar in the partition function but I was passing int type.

I should have used single quotes like...

Thanks!!

Sure, I can give you more details.

let's assume I have column named key with values, 1001,1002,1101,1201, 3001,3201,3202,3301, 5001,5201,5202,5203 and so on.

now I group the data for these key values and...

@Bhuvanesh: This is not an interview or quiz question. I am reviewing a code where this kind of style is being used. SO I thought wheather this is better from...

Hi,

Queries which are taking time are of type,

SELECT......

FROM SomeTable WITH (NOLOCK)

WHERE SomeColumn BETWEEN 47300 AND 47315

There are 4 tables which are similar to SomeTable and involved in similar query...

So, any pointers about where should I look to find the cause of these inconsistent rendering issue?

@Doug

Again, I completely agree to what you say, but what about the inconsistent errors? I will quickly summaries once again,

- Sometimes report gets rendered properly

- Sometimes report fails with a...

Daniel Bowlin (10/7/2010)

---

I don't know ANY users that would even...

Hi Raunak,

Thanks for the reply but I am aware about this. So what I am talking about is the way for setting the maximum and minimum memory limits in SSRS...

Thanks a lot!!

getoffmyfoot (9/30/2010)

---

Use perfmon to figure out if SQL Server is the memory hog or SSRS... thats a starting point.

If you set max memory in sql server to 2gb, and...