munnaonly (2/25/2013)
Yes, i referred the article, but i haven't see difference, is any other setting there ?
Errr... the entire first section of that article explains why partitioning does not get you an automatic performance improvement and what the point of partitioning is. What 'other setting' are you looking for?
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