To help improve performance, you need to change how you are filtering:

select distinct mn as "Month",s.name as "Name"

from flt f join mission m on m.mseq = f.mseq

join edt e on...

Colleen (8/5/2008)

---

Hi Greg...

Thanks so much for your help. I'm sure it would run perfectly if I could just create a function... :w00t:

With some analysis I believe it is...

R. van Laake (8/5/2008)

---

Hi there,

Thanks for your input.... however being a newbie about where (or where not) to place SP's I'm not quite getting it. I understand that when you...

I am guessing here - but, I think you are trying to deploy the report incorrectly.

You should be deploying to: http://servername/ReportServer

I suspect you are trying to deploy to: http://servername/Reports

As far...

A couple of things you should look at:

1) Setting MIN/MAX memory (which you have already done)

a) Make sure MIN is at least 1GB...

Great - glad I could help.

The sa account will be mapped to the user dbo when the owner of the database is sa. If you don't want sa to be dbo - then you...

First, you need to enable Database Mail (not SQL Mail, which requires a MAPI client be installed on the server - e.g. Outlook). Once you have configured Database Mail,...

BTW, according to BOL this has changed:

Starting with Microsoft SQL Server 2005, SQL Server allows specifying ordering columns from tables in the FROM clause that are not specified in the...

Can you post the query that is causing the problem?

Most likely the sa account is the owner of the database and is mapped to the 'dbo' user. If you want to prevent the application from using the sa...

Although you...

rbarryyoung (8/4/2008)

---

Either in pre-processing (the Load step of the ETL) or in post-processing (the Analysis client)....

Several ways, that I have seen. One is to calculate the running totals during the...

Jeff Moden (8/3/2008)

---

Heh... thanks for the feedback... I've done the same thing, many times. Didn't know for sure if you were on to something that I wasn't aware of...