Sean Lange (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

Sean Lange (3/7/2013)

---

Lynn Pettis (3/6/2013)

---

Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team asked...

dwain.c (3/6/2013)

---

Lynn Pettis (3/6/2013)

---

Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team asked what was offsides?"

Well, I've just...

TravisDBA (3/7/2013)

---

Agreed, but the propensity for this happening is much...

Thanks for the question.

Awesome Idea. Desks on wheels. Too many times moving teams has involved a day of lost work trying to pack it all up and move to the new...

Lokesh Vij (3/5/2013)

---

happycat59 (3/5/2013)

---

Mmm, why have "ISNUMERIC" as the heading for this question ? This question is not really about the ISNUMERIC function. How about getting the heading...

The slowest part of your reports is by far the data retrieval. This means that your tsql to get the data is the biggest impact.

That can boil down to...

JKSQL (3/5/2013)

---

So I can take that as when you apply a hint it is going to lock that table whether it is Tablock or TablockX while the update is going...

Ferb

Is the stored procedure that has many different parameters that could be passed in?

Do you see a lot of changes against the tables the procedure runs against?

What you are describing...

The X lock is coming from an update statement. The update while there is a table lock is not permitting the select to run until that transaction is committed.

+1

Thanks for the question.

You mentioned data retrieval and render time, how about processing time?

I am curious to know if any optimizations have been made towards SSRS settings.

How does the data retrieval compare when...

In addition to what Minaz threw out there, is the server Clustered? If so, verify that the location that the model db was moved to is on a resource...