Thread: SQL Query timeout issue

> let us see your query. iF theRe iS a wAy iN tHen theRe iS a wAy oUt..

> are indexes same on both dbs media table?

> Thanks for your reply..The INDEXES are same on both dbs "media" table. Vishal

> We'll definitely need to see the problematic query. Make sure your statistics are up to date as that's a very important aspect of query performance. UPDATE STATS... Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that everything you've done up until this ...

> The statistics and indexes are up to date. I understood the issue but not getting solution. Please refer below query. The user has a selection dropdown where he can select how many number of records he want to see (for example 10, 25, 50, 100, 500). Maximum is 500. There is a navigation button where he can click on “Next” to see next set of records. e.g. if he has ...

> replace NOT IN with NOT EXISTS or left join and try

> If your mediaid is sequential, you can store the largest value of mediaid in current resultset in a variable and use it like below - SELECT TOP 10 * FROM yourtables WHERE yourwhereclauses AND m.mediaid > @CurrentMAXMediaID --pass it as parameter from ui order by m.mediaid ,other orderbys Do you think this will work for you?

> Thanks Guys. I will try your suggestion on different scenarios and will let you know. Meantime I am trying using ROW_NUMBER() and CTEs. I will post these queries soon. I appreciate your feedback and response. Vishal

> good luck!