Good to see that the culprit was found.

Jasmine

The server from which it is disappearing, is it involved in replication?

Sean Lange (9/12/2011)

---

Well then....

select MAX(number) from

(

select top 95 percent number from PS_TestForOnline order by number

) MyAlias

You probably want a bit more sample data to prove this but it should be...

It largely depends on your environment. Baseline your system, check the info...

Excellent reference - same one I would have used had I not seen your post first.

When things are slow:

Find a process that is running slow and tune it

Create a process to help fill a need

Research something of interest -test it out

Write an article (SSC or...

Evil Kraig F (9/13/2011)

---

The same thing we do every night, Pinky.

We try to take over the WORLD!

Honestly, I'm here on SSC when it's slow, or I'm off trying to research...

Place your condition in the data flow arrow leading up to your derived columns. If column > 0 then one path, else send it a different path.

See if this is of any help.

http://www.sqlchick.com/entries/2011/1/25/whats-up-with-the-slow-ssrs-r2-rendering-in-sharepoint-2010.html

Yes. You would run the service packs again to make sure the client tools are patched.

Lowell (9/13/2011)

---

here's my take on it;

this query featuring a CTE lists all foreign keys, and if there is an index with the leading column on the child table or not.

if...

bcsims 90437 (9/13/2011)

---

Ray K (9/13/2011)

---

Finish...

maybe...

Nice question.