Sagar-636902 (11/25/2014)
Thanks both for the Reply,it is sql server 2012 enterprise edition sp1
Then there's no reason why you couldn't delve into the useful if not slightly painful realm of using Partitioned Tables. One of the best reasons in the world to use partitioned tables is to solve the very problems that you're having with your indexes.
--Jeff Moden
Change is inevitable... Change for the better is not.