and here are the results:

Here you go!

  |--Top(15)

       |--Nested Loops(Inner Join, OUTER REFERENCES[llu].[LeagueLevelId]))

            |--Nested Loops(Inner Join, OUTER REFERENCES

Hey RGR'us,

I ran the select statement and the result was immediate.

Yes indexes have been applied to those columns.

any more ideas?

Hi All,

I am sure you already have this, but just incase-here is the link to the hotfix (AWE memory allocation bug SP4)-http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en

Good Luck!

A note to support BJ's comments. I installed the 'fix' and now the AWE (memory allocation) problem is solved. I am going to monitor the systems I installed it on...

I installed the 'fix' and now the AWE (memory allocation) problem is solved. I am going to monitor the systems I installed it on and if I encounter any problems...

Hi Chris and all fellow concerned DBAs,

I have obtained an 'unofficial' fix for the AWE bug in SP4-I am going to run tests today and I will keep you posted.

Patrick

Hi,

Well I got a hold of an 'unofficial' fix for the AWE problem with SP4- I will perform tests today and post the results here.

Hey Vik,

Thanx for the link

Are you getting an error message when performing the backup and if so, what is it?

Hi Hans,

Read this under Service Pack 4 download-http://www.microsoft.com/sql/downloads/2000/sp4.mspx.

Thanx for the information. I am currently following the suggestion of datatype changing. This is going to take me a while as I have MANY tables! Where's a developer when you need one???...