I know this is not an answer to the question you've actually asked, but if your report is required to be accurate, remove the NOLOCK hints.

They're not a magic 'go...

If you're looking for 'self-service' reporting, have you consifered using SSAS and SSIS for this, rather than building your own solution?

It's a lot more intuitive for most end-users

Does it run OK if you add with recompile?

SQL Server backups of all types are an online operation. Having people working while they occur is no problem ta all. Are you taking log backups throught the...

Personally, rather than regenerate it like that for every query, I'd take the output and put it into a Date Dimension table

Err- Lynn...

Ah also...

Might be...

L' Eomot Inversé (5/2/2012)

---

There are two common reasons: first is that the person involved is being pushed into a management role against their will - that will hardly ever work;...

TravisDBA (5/1/2012)

---

Nothing is more frustrating than trying to relate a difficult technical issue to a non-technical manager after he/she asks you what the problem is. My dad used to have...

majorbloodnock (5/1/2012)

---

Eric M Russell (5/1/2012)

---

Most sales professions get paid on commission, so it seems to me that a company's "best" sales people (those who consistently open a large number of...

Are the filenames for the logs on both servers the same?

Have you tried checking that the appropriate permissions are in place? Does the login being used actually have access to that directory?

Just a gut feeling - never used C...

Have you tried taking the Access query and refactoring it appropriately as a SQL Server stored procedure and calling that from access instead?

As far as I'm aware, you cannot take a table snapshot (but there are rather talented people on here who may prove me wrong). If I were you I'd...