Partitioning in SQL Server 2005/2008
We have partitioned 5 large tables across 10 partitions (with 10 filegroups) and with a set of 5 – 6 users the performance was adequate, with minimal conflicts (like deadlocks etc), but we want to implement this scheme that can scale to say 300 users. With regard to this I have the following questions:  - [...]

Answer Question   |  April 28, 2010  5:19 PM
SQL Server 2005, SQL Server 2005 Partitioning, SQL Server 2008, SQL Server 2008 Partitioning