A question I get asked quite a lot is "how many files / filegroups should my database have?".
As we all know there is only one right answer to all of life's questions and that is: "it depends!".
Lucky for us the guys from the SQLCAT team have taken the time to explain a little how to evaluate how many files you need for specific workloads.
In the first post they talk about OLAP environments and imho this is a must read!
The Techdays (and launch event) are coming pretty close so get ready for some nice sessions about SQL Server 2008, Windows 2008, Visual Studio 2008, Hyper-V and more!
You can always pay me a visit at the Euricom stand. Tip: There will be "champagne" on Thurday ;-)
