I would start by going to the machine that is hosting your reporting site. If SSRS is not on that machine, there should be info to tell you where it...

drew.georgopulos (5/23/2012)

---

Two developers created queries that passed code review, yet, they yielded different answers. One practitioner coded the query with a where clause that specified a place of service, a...

I haven't looked into it, but can't you include a data modeler and report builder with SSRS? So there are some reports that are standard, some that you will...

Can you please post the errors you are receiving?

richardmgreen1 (5/23/2012)

---

If it's only a select query you're running initially, try putting :-

set transaction isolation level read uncommitted

as the first line of your query. I've noticed it helps to...

DBA_SQL (5/22/2012)

---

I think I am confusing. So, if we have more data, we get more pages...and vice versa right...So, at this point i think it is good to focus on...

MarkThornton (5/22/2012)

---

Lynn Pettis (5/22/2012)

---

Only thing that comes to my mind at the moment would be one or more long running transactions.

Could be other things, just not sure what at the...

timwell (5/22/2012)

---

OK. That won't help... 🙁

SQLKnowItAll (5/22/2012)

---

I think in order to...

MarkThornton (5/22/2012)

---

Yes, they are. 1 failed at 0030 last night, but they have run successfully since then.

Best...

EDIT: deleted comments... I must have missed a bunch of previous posts 🙂

timwell (5/22/2012)

---

I suppose it will depend if you want the locations to be independent of each other. For example, if your web application is in need of maintenance and you...

I suppose it will depend if you want the locations to be independent of each other. For example, if your web application is in need of maintenance and you need...

Lynn Pettis (5/22/2012)

---

timwell (5/22/2012)

---

We have 2008 R2 Web edition

This implies that the application is web-based. Does each remote site have their own web server and database server or do they...

So, for them to make a connection to SQL Server, they will need a connection on their machine. Whether or not you can use a file, I don't know....

Just saw this link in another post from Lowell: http://msdn.microsoft.com/en-us/library/ms143412.aspx