Sai Viswanath (6/18/2013)
Hi Gail,Simple he wants to improve performance (as told by the development team).
Then suggest to him that tuning the queries is the appropriate path as partitioning is not for performance.
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
Now, I have another 10 days left to do miracles :hehe:
Hire a consultant. There are no silver bullets for performance
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