June 6, 2010 at 9:00 pm
Hi,
I have around 10 tables, which i am joining in my sql queries...
and each table will have around 800,000 records...
I am using the Dense_Rank Over Partition clause in my inner joins..
does Dense_Rank and partition clause, will they create any time out problems ..right now i tested and it does not creates any problem...
but will it create any errors in any scenario
Can i use Nolock table hint for each table.will it fix the problem for time out
does it has any effect on the other transactions if i use Nolock..please help me with the doubts...
June 6, 2010 at 11:11 pm
I can't answer the "does Dense_Rank and partition clause, will they create any time out problems" question, as you've given virtually no information.
If you're concerned about performance, please post the query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
As for nolock, see - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply