One extra piece of info I just discovered:

In my large query statement, I have a in the where clause "WHERE rank>(((@pg-1)*@items_per_page)+1) and rank<=(@pg*@items_per_page)"

@pg and @items_per_page are passed in parameters.  If...

NEW INFO!

OK, The problem hasn't been happening much lately but I'm now copying this entire database to a new SQL Server and it again sprung its ugly head.  This time...

OK!!!

The problem happended AGAIN, this time with the table variable version of my SP (that piece of info is probably irrelevant). I could call the SP from query anaylzer...

Hi Robert,

This sounds just like what I'm experiencing.  My query is really not all that ugly as you can see and it gets called probably several times per sec, not...

Hi David, 

It's my understanding that a select in ()'s can not return more than one value.

table1 and table2 can be joined on weeknum and val1 also. 

How can I...

OK, more info!

This seems to be a LOCKING problem.  When this stored procedure is called from ASP, I see a TON of locks on the tempdb and on the 3...

Unfortunately, the problem is gone now, so I'll have to wait to see it again. 

SQL Server and IIS are on the same machine, so accessing via a remote browser...

Hi David,

Thanks for the tip regarding how to call the SP from ASP.  I've thought about this and agree that it my current issue.

I think that the fact that this...

I agree that it doesn't seem like a brute force type of attack. I'd think that in a brute force method, I'd see thousands of attempts per occurrence. ...

What's the best way to find out where the attack is coming from without hitting performance? Do I need to run profiler continuously on the server or on my...

ugh! Just found out that my hosting company had SQL Server set for a max of 152MB of RAM. That couldn't have been a help. They're bumping...

Thanks for all of the great input!

My site had some trouble again this weekend but I think the trouble was less due to writing static pages to disk. I...