I have a couple of projects in place to do table partitioning. I have identified the partition key and working on the range. With 230 million records, whats the best strategy to partition and if all file groups are on same set of disks, what benefit do I get? THanks
Hi Look at this Whitepaper http://www.sqlskills.com/resources/...g in SQL Server 2005 Beta II.htm#_Toc79339942 Thanks