Then try adding one,

Create index idxProductDetail on ProductDetail (ProductName )

Should do you

a) dont use 'sa' , 'sa' as user / password

b) read up on sql injection attacks

c) have you an index on ProductDetail.ProductName ?

Sounds as if you need some form of server side paging.

http://www.sqlservercentral.com/articles/paging/69892/

try this for starters,

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Then all you need is a sum

Anything by Itzik Ben-Gan would be highly recommended.

Ok , so we all have differing opinions of Celko, but a response after three and a half years :crazy:

http://www.sqlservercentral.com/Forums/FindPost1127806.aspx

Looks like homework...

http://efreedom.com/Question/1-5021993/Way-Make-SQL-Efficient

http://social.msdn.microsoft.com/Forums/en-CA/transactsql/thread/ee6e5643-2b7d-4bc2-a851-e6a407070d17

http://stackoverflow.com/questions/5021993/is-there-a-way-to-make-this-sql-more-efficient

Another thought......

Would these functions return an ANSI warning ie "NULL value eliminated from query"

As that may be being 'consumed' somewhere and causing the slow down.

Ive mocked it up on a...

Its not ANSI_WARNINGS , im guessing you are testing with SET STATISTICS TIME ON , that is your difference

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/11/24/the-observer-effect-in-action.aspx

As a general rule i would advise against using such things with out a full and proper understanding of exactly why.

Have you been able to identify the code that is...

I'd rather do an update query that takes a couple of minutes to execute - if it means improving the performance of my select query by even a second....

Thanks Jeff, nice suggestion. Done.

You cant really do that, maybe try a default column value....

But this seems like a wrong design to me. Ideally you would not be storing the url directly,...

Then...

QBAQ , i like it 🙂