Here are the indexes you have:

idx_acct clustered located on PRIMARY acct_id

idx_acct_stub nonclustered located on PRIMARY acct_stub

idx_name nonclustered located on PRIMARY acct_stub, acct_name

First, if most of your queries are like the...

Without capturing the required data at specific points in time for reporting, about the only other suggestion I have is to back out of the data the transactions entered after...

You are getting a key lookup because you are asking for all the columns to be returned in the query. SQL Server is using the nonclustered index idx_name to...

I don't think so, particularly in SQL Server 2005. Checking the Resource Governor in SQL Server 2008, it looks like you can only control CPU and memory resources. ...

Yep, I can do it without using a UNION.

I'm sorry, I don't see how we should help here. This is not that...

There is a difference, you have access to the database and the data, and to the SSIS package. This gives you a lot more info than we have, as...

I have some understanding of PeopleSoft has I help support the databases for our Finance and HR systems; as well as helping the PeopleSoft developers with SQL queries and tuning.

You...

No.

I'm right there with you.

Check out the db_ddladmin database role in BOL (Books Online) and see if this is what you need.

No problem, happens to us all at one time or another.

timscronin (12/14/2009)

---

Ok I am stumped, got dbmail to work however, when I wanted to add another name to the receipt line I get an error, can't find anything in BOL...

How about some sample data and what it should look like? In this case, you can show me what the parameters to the WHERE clause should be based on...

I am sure that there is a better way to do what you are asking. Problem is, I'm not exactly sure what you are trying to accomplish. Please...