Thanks guys...

Turns out that working with the vendor yielded some new indexes and performance is much better. I Still think there is plenty of room for imporvement, but I'm...

Darryl,

Thanks for the heads up. Thsi could be an issue, I have running SQL 2000 Enterprise Edition on Windows 2000 Server. It sounds like without the AWE option...

Thanks again...

I am on a mission to find memory for this server. I bet you could guess that it is a few years old. It may be tough...

Jeff,

You were right on... I added the PLE counter to PerfMon and when I observed the sloness and saw the PLE Counter drop from its normal value of about...

Ahhh... it seems that most of my testing was done with my account which is a member of the Local Admins group on the server. I get mapped to...

Thanks for the response.

What you describe is exactly why I haven't gone ahead with LS in my production environment.  What I need to know is what happens to the destination...

I'd vote for SQL Syntax along with the effects of different types of joins on the query outcome.

Many people get tripped up on mal-formed joins and where clauses....

I am a programmer turned DBA. In the past I have worked with Crystal Reports and Active Reports (vicariously through a college). We have been successful with both...