We are trying to partition a large history table. Being new to partitioning, I was trying to understand the concept of files and file groups. File groups can be set up in following three ways : 1. ...
I have a database in SQL Server 2008 with around 20 GB in size. And it is increasing rapidly. Somehow I can not add multiple independent harddisks to increase IO performance. If a add large table ...