For example, you have a very large database: OrderDetail. Sales department runs a large number of short-running T-SQL batches, which mostly perform the WRITE operation with data for current month. Administration department executes many long running queries, which mostly perform the READ operations with data for prior months.
Solution: Designing a partitioning scheme to store the current data in one partition on disk volume 1 and store the prior months data on disk volume 2. The RAID 0 could be used to improve the performance further.
